PanzerAttack
Board Regular
- Joined
- Jan 3, 2008
- Messages
- 197
I don't have the data in columns to allow another function but I want a Calc Field in my Pivot. Of course what happens is I only have 1 field with all my data.
What I want is =if( SumOfAmount ="Actual")/ SumOfAmount ="NPS")
But it wont allow this. How can I enter a calc field if my values aren't in columns?
What I want is =if( SumOfAmount ="Actual")/ SumOfAmount ="NPS")
But it wont allow this. How can I enter a calc field if my values aren't in columns?
