| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Calculations
How do I add a pivot table calculation that will show me the difference
between value fields over a particular column label? In this case, the column label is SOURCE, which has 2 fields, platform and ePEN. I'm trying to get the difference between platform and ePEN for various values, something like: SOURCE PLATFORM EPEN ORDER_COUNT ORDER_COUNT DIFF SITE_ID 1131 10 9 1 255 35 40 -5 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Calculations
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Calculations
Herbert,
Thanks for the mini-lesson. It works perfectly! "Herbert Seidenberg" wrote: Excel 2007 PivotTable Calculated Item http://www.mediafire.com/file/o4oyqi2hzzd/07_07_09.xlsx |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Calculations
Hi, where do I find the Insert Calculated Item option?
and where do I pick it on the pivot table? "Herbert Seidenberg" wrote: Excel 2007 PivotTable Calculated Item http://www.mediafire.com/file/o4oyqi2hzzd/07_07_09.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Calculations | Excel Worksheet Functions | |||
| Pivot Table Calculations | Excel Worksheet Functions | |||
| Pivot Table Calculations | Excel Worksheet Functions | |||
| Pivot Table Calculations | Excel Discussion (Misc queries) | |||
| pivot table without any calculations | Excel Discussion (Misc queries) | |||
Linear Mode
