Liny,

You could drop the "Type Forecast" into the Report Filter and filter out
blanks. This will then not show the levels where there is no forecast data.
Not sure if your data can have a budget amount and no forecast amount, in
that case set up a helper column with a trigger if both are blank and use
that column in the PivotTable Report Filter.


"Liny" wrote:

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?