6 Replies Latest reply: Jun 7, 2012 11:31 AM by Max Khesin RSS

    Urgent.. Hide Row in Pivot Table (Set Dimension Data in Pivot Table According Selected Month & Year)

      Hello all,


      I have a problem to show a report in pivot table. Please check attached excel file. This is a sample report that I exported from my qvw. You can see when I select Year = 2011 and Month = Nov, the report will automatic compare with last year in same month (Using Year and Month as Dimension).

      My expression is :

      sum({<Year={$(=max(Year)),$(=max(Year)-1)}>}Qty) --- For sum Qty

      sum({<Year={$(=max(Year)),$(=max(Year)-1)} >}Sales) --- For sum Sales


      For every month I have a table that store which region I want to show in my report. For Example:

      Nov 2010 = Region 001,002,003,004,005

      Nov 2011 = I just want to show Region 001,003,005


      The problem is how to set dimension data according to max month year data? So for sample excel file I attached, I just need to preview region 001,003,005.

      Anyone know how to solve it? Thanks before.