Hiding values in a pivot table

[#1]

Hi -

Is it possible to hide scpecific values in a pivot table?  For example:

Dim 1

Red -----------> Show

Yellow -------> Exclude from the pivot table

Greeen ------>Show

Thank you!

[#2]

Hi

i don't remember exactly(sorry)  but it does exists the possibility to unactivate a expression

if (Value = Yellow,  <unactivate>)

This has the same effect as tick/untick the "Activate" box in Expression Tab

Chris