Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 130
- Office Version
- 365
- Platform
- Windows
Hey
I am having an issue with a slicer on a file I have taken over from someone else.
I will try simplify the issue because it is a work related file and I don't want to reference work.
I have an input file with data. From the input file I am interested in the following columns:
1. "Version" - under Version there will be two options. January or June.
2. Country - Could have 10 different countries in the list
3. Cities within the Country - We could have 5 cities within each country - so around 100 cities in total
4. Totals $
So I have two pivot tables which I will be using to compare against each other in terms of $.
The first pivot table will have a Slicer which will select the January option in the Version column and the second pivot table will have a slicer which will select the June option in the Version column.
I will then have a Slicer for Country and I will have it so that the Slicer is connected and once I select a Country in the Slicer it will update both pivot tables simultanteously
I have another slicer for Cities within the Country. So again similar to the above, I will have the Slicer connected so it updates both pivot tables.
The issue I am having and I presume it is very simple but I cannot figure out is this.
When I select a particular Country in the Slicer - it updates the value for all the cities under that Country - which is fine and what I want it to do BUT the issue is that within both pivot tables it still shows the cities for all other countries, even though the amounts are blank in those cities as their Country was not selected in the Slicer.
I am expecting that when I click the Country only the cities from that Country will appear in the pivot not all cities across all countries?
Any idea what I am doing wrong?
Thanks
I am having an issue with a slicer on a file I have taken over from someone else.
I will try simplify the issue because it is a work related file and I don't want to reference work.
I have an input file with data. From the input file I am interested in the following columns:
1. "Version" - under Version there will be two options. January or June.
2. Country - Could have 10 different countries in the list
3. Cities within the Country - We could have 5 cities within each country - so around 100 cities in total
4. Totals $
So I have two pivot tables which I will be using to compare against each other in terms of $.
The first pivot table will have a Slicer which will select the January option in the Version column and the second pivot table will have a slicer which will select the June option in the Version column.
I will then have a Slicer for Country and I will have it so that the Slicer is connected and once I select a Country in the Slicer it will update both pivot tables simultanteously
I have another slicer for Cities within the Country. So again similar to the above, I will have the Slicer connected so it updates both pivot tables.
The issue I am having and I presume it is very simple but I cannot figure out is this.
When I select a particular Country in the Slicer - it updates the value for all the cities under that Country - which is fine and what I want it to do BUT the issue is that within both pivot tables it still shows the cities for all other countries, even though the amounts are blank in those cities as their Country was not selected in the Slicer.
I am expecting that when I click the Country only the cities from that Country will appear in the pivot not all cities across all countries?
Any idea what I am doing wrong?
Thanks