Pivot Table: Limited nr of Calculated fields to show?

S

SG

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table calculated field: multiply Sum of FieldA with Max ofFieldB 4
Different format for Calculated Item in pivot table 2
Total Not Summing Correctly on Calculated Fields in Pivot Table 0
Calculated Item in Pivot Table Adds Rows with Zero Values 0
Pivot table - Gross Profit Percentage subtotal with multiple items 0
How to show all formulas of cells in cells (and not the calculated result) ? 10
How to increase calculations speed in pivot table with calculated fields & items 0
Using a Pivot Table Calculated Field to get a Unique Count 1

Top