BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 333
- Office Version
- 2010
- Platform
- Windows
I have a simple PivotTable that is just counting 1 column of data called "Conditions".
I have added "Conditions" which is text to "Rows", and the Value is a count of the "Conditions".
What I would now like to do is add a % column to the PivotTable using a fixed division of 24, i.e. SUM(Conditions / 24)
However, I can't get the formula to work using a calculated field
It works if I add a formula manually to an adjacent row i.e. =GETPIVOTDATA("Conditions",$A$3,"Conditions",$A4)/24
Then copy it down.
But, is it possible to create it using a calculated field?
I have added "Conditions" which is text to "Rows", and the Value is a count of the "Conditions".
What I would now like to do is add a % column to the PivotTable using a fixed division of 24, i.e. SUM(Conditions / 24)
However, I can't get the formula to work using a calculated field
It works if I add a formula manually to an adjacent row i.e. =GETPIVOTDATA("Conditions",$A$3,"Conditions",$A4)/24
Then copy it down.
But, is it possible to create it using a calculated field?