Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table: Limited nr of Calculated fields to show?
Hi There,
I Have a couple of "original" Fields: Sum of UNITS Sum of 0802 SALES Sum of 0802 COGS Sum of 0802 GROSS PROFIT Sum of 0802 SAD Sum of 0802 EBIT I created a couple of Calculated fields: %Change in Units %Change in NS Sum of ANS (=Sales/units) Sum of Avg COGS(=COGS/units) Sum of GP/Unit (=GP/unit) Sum of GP%NS(=GP/Sales) Sum of 0802 SAD%NS (=SAD/NS) Sum of 0802 EBIT%NS (=EBIT/NS) I wanted to show them al in in my rows like: Sum of UNITS 1,634,584 2,257,656 %Change in Units -27.60% Sum of 0802 SALES (101,492,892) (140,819,920) %Change in NS -27.93% Sum of ANS (62) (62) Sum of 0802 COGS 76,422,929 104,045,480 Sum of Avg COGS 47 46 Sum of 0802 GROSS PROFIT (25,069,963) (36,774,440) Sum of GP/Tire (15) (16) Sum of GP%NS 25% 26% Sum of 0802 SAD 34,009,379 29,964,328 Sum of 0802 SAD%NS XXXXXXXX Sum of 0802 EBIT 8,939,416 (6,810,112) Sum of 0802 EBIT%NS XXXXXXXX But my last 2 Calculated fields do not show: these ones: Sum of 0802 SAD%NS XXXXXXXX Sum of 0802 EBIT%NS XXXXXXXX I only get: Sum of UNITS 1,634,584 2,257,656 %Change in Units -27.60% Sum of 0802 SALES (101,492,892) (140,819,920) %Change in NS -27.93% Sum of ANS (62) (62) Sum of 0802 COGS 76,422,929 104,045,480 Sum of Avg COGS 47 46 Sum of 0802 GROSS PROFIT (25,069,963) (36,774,440) Sum of GP/Tire (15) (16) Sum of GP%NS 25% 26% Sum of 0802 SAD 34,009,379 29,964,328 Sum of 0802 EBIT 8,939,416 (6,810,112) Nevertheless I could add 2 "normal" fields if I want ..they DO show. eg: Sum of UNITS 1,634,584 2,257,656 %Change in Units -27.60% Sum of 0802 SALES (101,492,892) (140,819,920) %Change in NS -27.93% Sum of ANS (62) (62) Sum of 0802 COGS 76,422,929 104,045,480 Sum of Avg COGS 47 46 Sum of 0802 GROSS PROFIT (25,069,963) (36,774,440) Sum of GP/Tire (15) (16) Sum of GP%NS 25% 26% Sum of 0802 SAD 34,009,379 29,964,328 Sum of 0802 EBIT 8,939,416 (6,810,112) Sum of 0802 EBIT 8,939,416 (6,810,112) Sum of 0802 EBIT 8,939,416 (6,810,112) Are there limitations on the number of Calculated fields a PT can show? The Calculated fields: Sum of 0802 SAD%NS & Sum of 0802 EBIT%NS are properly created it´s just that they dont show... Anyone Please? Many many thanks in advance, SG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statements in Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
Can I use IF function in calculated fields in a pivot table? | Excel Worksheet Functions | |||
Excel 2000 Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) |