Pivot Table Formula

illinibenz

New Member
Joined
Nov 29, 2005
Messages
11
I need help trying to use a calculated field in my pivot table. I would like to use something like =hours/AVERAGE(hoursinmonth)

The pivot table can divide SUMs only if I am not mistaken so how can I accomplish this?


Thanks!
Ben
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

mrhartley

Well-known Member
Joined
Mar 8, 2005
Messages
564
One thing you could try, its something I do form time to time.

If you know if your PT will not change size, i.e the columns and rows will not grow or reduce (I often use PT's for a summary display rather than for changing views of data) then you could add in the next column after the PT has finished your formula.

So lets say the last column of your PT is column E, now in column F, enter your formula as you want it.

I have explained that really badly, sorry but what I mean is that you do not have to use pivot fields/pivot items in order to run formula over PT's

Have a think and come back and I will try and post an example if it's not clear

Regards
Mark
 

illinibenz

New Member
Joined
Nov 29, 2005
Messages
11
That is true, I never thought about it. But, these PTs change size everyday...

It seems to me that there would be a way to have a PT do a formula. Seems odd that I can't divide an average by a sum.

Thanks!
Ben
 

Watch MrExcel Video

Forum statistics

Threads
1,118,540
Messages
5,572,791
Members
412,484
Latest member
deezina07
Top