Pivot Table / Selection explanation

[#1]

Hi! I create a pivot table. I need an explanation about:

1) How can I hide the records where 2011 fields are null/zero?

2) How can I show only records where department fields are C or D?

You can find an example attached.

Any suggestions greatly appreciated.

Andrea

[#2]

Attached with rows suppressed when Apha 2011 is zero/null.

[alexandros17]

Sorry,

I didn't see before,

here is your example modified;

obviously if you need to check all columns of 2011 you will have to extend the condition, something like

If(column(1)=0 and column(2)=0

And so on ...

[#4]

Thank you so much for your help!

[#5]

Thank you so much for your help!