excel pivot table and simple division column
Hi,
I have a simple pivot table with 3 fields:
Month, quantity, tot amount,
I need a column which calculates tot amount / quantity.
I need also that in the final tot row it does the same:
tot of tot amount / tot of quantity.
Is it possible?
I have a simple pivot table with 3 fields:
Month, quantity, tot amount,
I need a column which calculates tot amount / quantity.
I need also that in the final tot row it does the same:
tot of tot amount / tot of quantity.
Is it possible?
ASKER
Thanks Makrini,
I use office 2007.
Now I try.
I use office 2007.
Now I try.
ASKER
I don't understand why,
but I have not Fields tab or something like that.
but I have not Fields tab or something like that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks,
at the end I found it!
at the end I found it!
In the ribbon under Pivot Table Tools - Options
Choose Fields, Items and sets, and choose "Calculated Field"
Then name your new calculation whatever you choose and create a formula totamount/Quantity
Click "Add"
(Using Excel 2010 - it's named something *slightly* different in 2007 - If you are using earlier than that you can find it a different way - let me know if you are)