Forum Discussion
Compare Data at multiple level
I'm in the requirement gathering phase. Solution we are looking for is to compares sales by mutilple slicer.
Step 1: User Select Region for Slicer#1 then User Selects another Region from Slider#2 to Compare the sales between selected region
Step 2: User Selects Vendor from Slicer#3 then User Selects another Vendor from Slicer#4 to Compare sales by vendor
So at a very high level I would like to first compare sales by region and then within those regions sales by vendor.
I hope this helps.
Anonymous attached is something I did for another post where a user select different values from slicer and then compares it. You can extend the use of it to meet you needs.
- Anonymous7 years agoNot applicable
parry2kThanks, but how would multiple slicer work?
- parry2k7 years agoSuper User
Anonymous did you looked at my file? You can use similar approach for next level of slicers.
- Anonymous7 years agoNot applicable
Yes, So I should create over 12 independent tables like you created Slicer1.Budget. That would complecate the model a lot. Any other option?