Not exactly sure, but something like below works?
Not achieved by one click, and need to select "All" with visual check to confirm select "ALL".
The merit is very easy to add.
Drag "Plan MFG" under All vendors to create hierarchy.
select_All_SM_10.2.twbx 2.2 MB
When I create a dashboard and create filter on PLANT MFG.
I want to see ALL_VENDORS as one of the option like ASE-CL or ASE-KH . and when the user select ALL_VENDORS option
the table should show the full consolidation which Iam able to see but I dont see the ALL_VENDORS option in the filter
Also in the current workbook when I select ASE-CL I see ALL vendors columns as ALL Vendors instead I want to ee
ASE-CL becuase I selected only ASE-CL
I don't know your connection allows or not, but one way is below.
This duplicates data and I don't recommend though. (Creates another big confusion for users)
Hi Shri Siva
If you have further questions, please reply here.
If the post helped to solve your issue, please mark my answer as CORRECT / HELPED to close the thread, not from inbox but from original post.