Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table - Blank SubTotal in Calculated Field
Hello,
I looked around without success. In a Pivot table, there are 2 existing fields, linked to a spreadsheet, 'N' and 'N-1' for items split in 2 groups. I created a Calculated Field "Y/Y"= 'N'/'N-1'-1 to simply get the variation between the 2 years. N N-1 Y/Y Group 1 a b % c d % Total Group 1 U V Group 2 e f % g h % i j % Total Group 2 W X Grand Total Y Z % The Y/Y results are corrects for each items and the "Grand Total". The problem is that nothing appears for the Subtotal Y/Y variation. Could you help? I use Excel 2000. Tks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table calculated field and subtotal | Excel Worksheet Functions | |||
Re-using calculated field in another pivot table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) |