Hi, Ling Qi
Have you tried to edit the "Caption" with your own way so that you can better organize the information reading?
Thank you for response and great idea.
How ever, I tried to edit "Caption", some filters are not showing all members selected, example as below. How do I make "Caption" to show all member selected? or something like "The Department Name filter keeps 195 of 213 members, except for 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18"?
The Department Name filter keeps 195 of 213 members.
The Product filter keeps 24 of 30 members.
The Product Name filter keeps 6 of 20 members.
Hi, Ling Qi
I don't think it is doable with all your 20 filters together.
Hi Ling Qi,
Create new worksheet as "Current selection" and apply all filter to this worksheet,
In worksheet title insert all the dimension and measure filters used and format it in easy and readable statement.
Hope this helps you. - don't forget to mark correct and useful if it meets your requirement.
Thank you Zhouyi for your help, I worked out inserting a worksheet with all filter values as Bhujang Hundre mentioned.
Hi Bhujang Hundre,
Yes, it works. Thank you very much!
That's really cool.