Suppress Zero Value Column in Pivot

[#1]

Hi all,

I have one pivot table that contains the customer and year dimension. In the expression, I have current year and previous year sales. But when I put the year dimension under the expression, the non-related year will still be displayed, but all values are zero. How can I suppress this?

Attached is the sample scenerio. For example, when 2008 is selected, 2007 shouldn't be shown in the Current Year column. Same for Previous Year (2008 shouldn't be shown).

edit: The time dimension must be drillable.

[#2]

Hi,

   it is because of your "Year" dimension in your drill group.If you removed your "Year" then you will not get any issues.I have attached the appln here.

-Jai

[#3]

Hi Jai,

Sorry, I forgot to mention that the time dimension need to have a drill down option. So, removing the year will remove the drill down function.