View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liny Liny is offline
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?