I have added action into the rows for the desired output.
If you go by navigation you will not get this output.
it is necessary to see the Sub-category on dashboard 2 without any navigation?
because on navigation I am getting this result which is your desire output
The specified item was not found. can you share your opinion on the same.
Thanks and regards,
The problem in your design is that there is no Region dimension in your second dashboard. So when the action reaches the 3rd, it doesn't have a Region to apply to it. So, the key is to add Region in dashboard 2.
Yes. I tend to agree with Rohan Malusare that the dashboard 2 is only there to provide further details. Users won't see it in the normal course of action.
Here is my version
The dashboard 2 is a straight table. I hid the Region header to be the same as your initial design.
Got an alternative by setting Dashboard 2 to be blank when filtering is cleared. Option in the action filter: excluding all values.
It looks a bit better.