Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have this small pivot table. Here is part of it. I hope this goes across
correctly as it's very hard to retain the columns as they should be once I post this: COL A COL B COL C COL D % DIFFERENCE YEAR MONTH WE PAID FROM LAST MONTH 2005 ROW 10 APR $6,204.40 ROW 11 MAY $25,634.46 313% ROW 12 JUN $1,755.81 -93% ROW 13 JUL $3,435.61 96% ROW 14 AUG $4,209.09 23% The last column (% Difference) has been added manually with the formula =SUM(C11-C10)/C10. I can't figure out how to enter this as a calculated field. Is this formula too advanced for pivot tables? Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |