Custom formula in Pivot Table
Posted on 2002-06-13
I am fiddling about with a Pivot Table to analyse my mobile phone bill and have come up against a small problem. I have been able to organise the Pivot Table as follows:
Person Called Data SMS Voice Call
Person1 Sum of Charge Amount
Sum of Duration
Count of Call Type
(I appreciate that EE will change the layout of the table due to fonts, but if you cut and paste into notepad, you should be able to recreate it).
Basically, what I want to be able to do is to add a new row Average call cost. The only problem is that for SMS I want it to be the "sum of charge amount" / "count of call type" and for Voice Call "sum of charge amount" / ("Sum of duration" * 25 * 60). I'm obviously doing something wrong, since inserting a new row myself and altering the formula doesn't seem to work. Given that the duration of an SMS is always 0 and I want to avoid horrid "#DIV/0!" messages in the table, I would prefer to only have one row (i.e. I would prefer not to have two averages, one by duration and the other by count).
Hopefully, I'm missing something simple???