Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've created a pivot table in the following format:
'Sales $ per Unit Sold' Mar Apr May Customer1 $1.00 $1.50 $2.00 Customer2 Customer370 Total There are more columns but for example purposes this should be adequate. The dimention 'Sales $ per Unit Sold' is a formula that divides the undisplayed columns 'Sales $' by 'Unit Sold'. What I'd like to do is create another column with a formula calculating the month-over-month % increase in 'Sales $ per Unit Sold'. For example: (formula???) 'Sales $ per Unit Sold' 'Mth over Mth Increase' Mar Apr May Mar Apr May Customer1 $1.00 $1.50 $2.00 na 50 33% Customer2 Customer370 Total Is this possible??? Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table fields | Excel Discussion (Misc queries) | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Pivot Table Fields | Excel Worksheet Functions | |||
Pivot Table page fields | Excel Discussion (Misc queries) |