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