Pearl_022
New Member
- Joined
- Jan 21, 2021
- Messages
- 22
- Office Version
- 365
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
Hi,
I am trying to calculate GETPIVOTDATA but I am not sue how I can get my result. I would like to get result in manner where I can see total batches and when I apply site filter It should work. I tried several things bit it is not working. Any help would be appreciated.
This is my pivot table
I have Year and Site as a filter and I want to make site filter work with my total batches and total rejection in another sheet (Dashboard view) when I put Getpivotdata calculation there
Thanks in advance.
I am trying to calculate GETPIVOTDATA but I am not sue how I can get my result. I would like to get result in manner where I can see total batches and when I apply site filter It should work. I tried several things bit it is not working. Any help would be appreciated.
This is my pivot table
I have Year and Site as a filter and I want to make site filter work with my total batches and total rejection in another sheet (Dashboard view) when I put Getpivotdata calculation there
Row Labels | Sum of Totalbatches | Sum of TotalRejection |
Jan | 96 | 15 |
Feb | 25 | 2 |
Mar | 34 | 0 |
Apr | 10 | 2 |
May | 38 | 4 |
Jun | 24 | 7 |
Jul | 9 | 0 |
Aug | 10 | 2 |
Sep | 15 | 9 |
Oct | 25 | 2 |
Nov | 9 | 0 |
Dec | 22 | 11 |
Grand Total | 317 | 54 |
Thanks in advance.