Forum Discussion
Compare Data at multiple level
Hi Anonymous
The question seems to be very ambigous can you share some data and the expected result.
Regards
Affan
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.
- parry2k7 years agoSuper User
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.
- Ashish_Mathur7 years agoSuper User
Hi,
There should be 1 slicer for all Regions and another slicer for all vendors. Why would you want to have 2 slicers for Customers and another 2 for vendors?
- Anonymous7 years agoNot applicable
Ashish_MathurThere are 6 different fields to compare Region, Country, Vendor, Product, Supplier, Customer * 2 = 12
We want user to compare Region with another region and so on.
- Ashish_Mathur7 years agoSuper User
Hi,
You still do not need 2 slicers for each. If you drag Region to the column or section and also have a slicer, then when you select a specific region from the Region slicer, only those 2 regions will be visible in the visual.