Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table calc field problem | Excel Discussion (Misc queries) | |||
Calc on Pivot Table | Excel Worksheet Functions | |||
Pivot table to calc by group | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total - Calc Item | Excel Worksheet Functions | |||
Pivot Table - Calc Item Problem | Excel Worksheet Functions |