How about using "Set Action"?
As the Attachment.
assume the data is :
Sheet1 is the grid, and Sheet2 is the filter.
In Sheet1, the ratio of total calculated by DispName.
And the DispName worked with set action, (Cate-Sub as a set.)
- In the Set, ==> Cate-Sub Name
- Out of the Set ==> Cate Name
if choose furniture - Chairs
If choose furniture - Chairs and paper
If choose all
Sample0129.twbx 1.0 MB
Thank you very much, ArseneXie. This works great with limited number of values in category and sub-category.
In my real dataset, I have 15 categories and about 50 sub-categories. And this can change every month. So I want to avoid maintaining manual set. Is there an alternate way to achieve this?
Also, is there an alternate approach to set actions? We are currently on 10.5. We will move to 2018.3 but later this year. Would like to add this in my dashboard before we move to 2018.3.