Hi,
I am hoping you could help me please. I have a number of data tabs, and use individual pivot tables to get the necessary information before copying into another report.
Basically, I have one pivot table looking at averages (below) however when I physically calculate the grand totals I get a different number than the pivot table is reporting. The pivot is reporting the Average of Week Days To Fill as 102, however when I calculate the totals I get 104.
I appreciate it is probably something to do with the format of the numbers, which are currently formatted as Numbers, but I am hoping someone could please point out what I am clearly missing!
Sorry and thank you in advance for your help,
Sawdeeka
I am hoping you could help me please. I have a number of data tabs, and use individual pivot tables to get the necessary information before copying into another report.
Basically, I have one pivot table looking at averages (below) however when I physically calculate the grand totals I get a different number than the pivot table is reporting. The pivot is reporting the Average of Week Days To Fill as 102, however when I calculate the totals I get 104.
I appreciate it is probably something to do with the format of the numbers, which are currently formatted as Numbers, but I am hoping someone could please point out what I am clearly missing!
Sorry and thank you in advance for your help,
Sawdeeka
Row Labels | Average of Request to fill approval | Average of Recruitment - Total Processing Time (excl. Advert Live) | Average of Advert live | Average of Days Taken - Selection Panel | Average of Days Taken - Delegate Approval | Average of Recruitment - Processing Letters | Average of Week Days To Fill |
Administration | 9 | 4 | 20 | 29 | 29 | 6 | 96 |
Allied Health | 9 | 13 | 17 | 31 | 17 | 3 | 90 |
Nursing | 6 | 4 | 12 | 64 | 26 | 3 | 115 |
Grand Total | 8 | 8 | 16 | 45 | 23 | 4 | 102 |