Nested Column condition

[#1]

Hi All,

I'm just wondering how we can do a condition on nested column of a pivot table.

If you look at the attached file you will see that I have year on the top  and nested columns. I want to show the Nb. Cust just for the year 2010 and I want to remove the other Nb. cust of the other years.

Any idea is appreciated.

Thanks

[hic]

Remove the "Show All Values" for the dimension "Year" (Chart Properties - Dimensions). Then the other year columns will disappear when you have selected 2010.

[#3]

Thanks for replying,

What I want to do is that show the report for all years but i want to see "Nb. Cust" just for the year 2010. I tried to do with condition but it did not work.mybe my condition was not good .

Thanks,Nima