E
excelCJG
Hi, I am trying to create a formula in my pivot table that refers to a grand
total. I know this was not able to be done in the older versions, but I had
heard this would be available in 2007 version. Is it, and if so how do I go
about doing it?
Specifically, here is a subset of my pivot table:
Data
product Sum of Consumption Sum of Capacity Formula
1 540 998
=540/1949
2 451 608
=451/1949
3 273 343
=273/1949
Grand Total 1264 1949
=1264/1949
As you can see what I am trying to do in the formula column is take sum of
consumption for each product and divide by the Grand Total of Sum of
Capacity. Any help would be greatly appreciated. Thanks!
total. I know this was not able to be done in the older versions, but I had
heard this would be available in 2007 version. Is it, and if so how do I go
about doing it?
Specifically, here is a subset of my pivot table:
Data
product Sum of Consumption Sum of Capacity Formula
1 540 998
=540/1949
2 451 608
=451/1949
3 273 343
=273/1949
Grand Total 1264 1949
=1264/1949
As you can see what I am trying to do in the formula column is take sum of
consumption for each product and divide by the Grand Total of Sum of
Capacity. Any help would be greatly appreciated. Thanks!