2 Replies Latest reply: May 23, 2011 1:05 AM by Khim Hoe Tan RSS

    Suppress Zero Value Column in Pivot

      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.