LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default pivot table calc item

I am running an issue with the Excel pivot table calculate item. The source
of data comes from Oracle. The data is bought into to Excel and display them
in the pivot table. There are two fields: level and type. Type has two values
of fcst and budget.

This is what the pivot table looks like:
diff is the calucated item (type[fcst] - type[budget])

type
level fcst budget diff
BNF 20 20
FAC 50 60 -10
MKT 10 5 5
INS
OTH 5 9 -4
TE

The levels with data are fine, but it also shows those levels(INS, TE) that
have no data. How do I exclude those no data levels(eg INS, TE) from showing
up in the pivot table?

 
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
Pivot Table calc field problem Valeria Excel Discussion (Misc queries) 0 January 9th 07 09:42 AM
Calc on Pivot Table Frick Excel Worksheet Functions 1 March 10th 06 10:11 AM
Pivot table to calc by group xlcharlie Excel Discussion (Misc queries) 0 January 24th 06 10:40 PM
Pivot Table Grand Total - Calc Item cjb2486 Excel Worksheet Functions 0 June 13th 05 08:33 PM
Pivot Table - Calc Item Problem Scott Excel Worksheet Functions 2 June 2nd 05 01:53 AM


All times are GMT +1. The time now is 08:57 AM.

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

About Us

"It's about Microsoft Excel"