Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SG SG is offline
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If statements in Pivot Table Calculated Fields Carmen Excel Discussion (Misc queries) 2 April 4th 23 12:57 PM
Can I use IF function in calculated fields in a pivot table? Bloke in Excel Trouble Excel Worksheet Functions 2 April 16th 06 09:46 AM
Excel 2000 Pivot Table Calculated Fields GreyPilgrim Excel Discussion (Misc queries) 0 March 28th 06 11:07 AM
Pivot Table with Calculated Fields Florence Excel Discussion (Misc queries) 3 January 20th 06 01:57 PM
Sum of Calculated fields in Pivot Table Graham Excel Discussion (Misc queries) 0 July 4th 05 03:47 PM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"