Hi,
I have a pivot table summing Department and Position hours and cost:
When I go to grab the data for another worksheet, I'm summarizing for department and position separately using vlookup to pull from the pivot table:
Why would these grand totals be different?
I have a pivot table summing Department and Position hours and cost:
Row Labels | 1/6/2020 - 1/12/2020 | 1/13/2020 - 1/19/2020 | 1/6/2020 - 1/12/2020 |
115 | 72.98 | 70.70 | $1,250.88 |
1104 | 72.98 | 70.70 | $1,250.88 |
130 | 289.58 | 298.58 | $4,548.22 |
1301 | 120.65 | 127.10 | $2,008.82 |
1304 | 37.50 | 38.50 | $699.38 |
1306 | 131.43 | 132.98 | $1,840.02 |
When I go to grab the data for another worksheet, I'm summarizing for department and position separately using vlookup to pull from the pivot table:
Total Hours | Total Cost | |||
Departments |
|
| ||
Positions |
|
| ||
Why would these grand totals be different?