Show Parent when no child + selection
My lists are as follow. Parent: Mission --> Programm --> Activity --> Expense (lowest level)
My objective is to put in place a filter that allows me to see the Activity items even though I have no existing Depense under the acitvity, combined with a filter where the user can select to narrow the view on one acitvity (in a module that has Expense dimension).
First in the process the user can select on different level of the hierarchy through line items published on the dashboard. If the user select (for example) Activity 1 the module should only display activity one.
If user doesn't select anything, all activities (and rest of hierarchy) should be displayed in the view.
I managed to show all the activities (with and without child) by creating a 'True' boolean and another item saying 'if true then 1 else 0' and applying a formula summary method. This works and shows every level of the hierarchy However, I cannot find a workaround to be able to show only the activity selected in the filter.
Thanks in advance for you help.