Assume there are 10 measures (M1, M2, …, M10) in my analysis. From the user perspective these 10 measures are categorized into 3 different buckets (B1,B2,B3).
B1 = M1, M2, M3, M4
B2 = M5, M6, M7
B3 = M8, M9, M10
I wanted to create a control on the top for buckets and the pivot should be filtered based on above Bucket to Measure mapping.
Ex: If I choose B2 in the controls, I should be able to see only M5, M6, M7 measures.
Thanks in Advance