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.
The problem you face is in the module dimensioned by Expense, if there are no children, there is effectively no data at that level.
It might be worth posting some screenshots of your dashboards, but from what I've understood I would create a module by activity and just display the rows and use this as a selector itself. The displayed activities should be filtered based on the user selection. The lower grid, by expense, should then be set to synchronise to this module.
In my example below, I have just used a page selector for Program to synchronise the activities instead of a filter for simplicity.
It is indeed what we have at the moment (see screen shots):
1) user select filter that filter the first table per activity
2) user select an activity in the first table
3) selection synchronizes with tables underneath
However we had some comments from the end user that didn't understand that their filter were not applying to all the tables. The objective would be to apply the filter selected in the first step in the second table (that for now has expenses only for some activities)
I'm a little confused because the approach above from @Sathya will work for any grid where you use the filter, but if there are no expenses under the activity then there should be nothing to show anyway, so the fact the parent field is blank doesn't matter
What do you want the grids to show if there are no expenses under an activity?