I've created a pivot table and when I drill down it's showing all the data. I've tried multiple times and it's always the same. I think it might have to do with the fact that I'm trying to drill down on calculated cells.
The table looks like this.
Group Jan 1 Count New Hires Transfers Dec 31 Count
1 15 2 1 16
2 20 1 2 18
3 60 0 0 60
The table looks like this.
Group Jan 1 Count New Hires Transfers Dec 31 Count
1 15 2 1 16
2 20 1 2 18
3 60 0 0 60
