Carin
Board Regular
- Joined
- Feb 4, 2006
- Messages
- 224
I have two pivot tables that feed off of the same data.
Pivot1: I have four column labels: 1, 2, 3, 4
Pivot source data column E has either a 1, 2, 3, or 4
My Row Label are cities in the area - so the pivot will list the city and tell you many of 1, 2, 3, or 4 there are in the source data.
Problem - if my source data does not contain one of the choices: let's say 2, then the Column labes read 1, 3, then 4. Everything seemed reasonable until the next month's report had a 2 in it. My Column Label still read 1, 3, and 4. I have to select the Count of City Name dropdown and check the number 2. Then my Column Lables are sorted like this: 1, 3, 4, then 2.
Is there a solution to this?
Pivot2: I have a pivot table for each number listed above: 1, 2, 3, and 4. Pivot1 just gave a count per city and Pivot2 actually shows the data that is being counted. When 2 was missing from the data, my pivot table that is filtered to only show 2 now shows ALL. Once I received my new monthly report, I had to select the report filter dropdown to select 2.
Is there a solution to this?
Thank you
Pivot1: I have four column labels: 1, 2, 3, 4
Pivot source data column E has either a 1, 2, 3, or 4
My Row Label are cities in the area - so the pivot will list the city and tell you many of 1, 2, 3, or 4 there are in the source data.
Problem - if my source data does not contain one of the choices: let's say 2, then the Column labes read 1, 3, then 4. Everything seemed reasonable until the next month's report had a 2 in it. My Column Label still read 1, 3, and 4. I have to select the Count of City Name dropdown and check the number 2. Then my Column Lables are sorted like this: 1, 3, 4, then 2.
Is there a solution to this?
Pivot2: I have a pivot table for each number listed above: 1, 2, 3, and 4. Pivot1 just gave a count per city and Pivot2 actually shows the data that is being counted. When 2 was missing from the data, my pivot table that is filtered to only show 2 now shows ALL. Once I received my new monthly report, I had to select the report filter dropdown to select 2.
Is there a solution to this?
Thank you