Hi All,
I have a dashboard with three sheets, segment, region, subcategory. I enabled each sheet to work as a filter. Meaning, segment can filter region and subcategory, region can filter segment and subcategory. Idea is to filter entire dashboard by any sheet(s).
When I filter using one sheet it work well. Here filtering using segment sheet
Now, if I select a value from Region sheet, Subcategory sheet is not passing previous selection, just passing values selected from the Region sheet. So, grand total for the Subcategory sheet is not adding up to 86279.
Ideally result should be combination of values selected in the two sheets. I want to get below values for same selection using filter action.
Is there a way to get the desired result using filter action? If not, what's the best way to achieve this kind of requirement?
It would be great if someone helps getting it through.
Thanks
Create a copy of the category dimension and in the subcategory sheet, replace the existing category field with the copy one. It should work the way you want.
