6 Replies Latest reply: Jul 8, 2011 8:58 AM by estebanjcampos RSS

    Select diffrent maximun months for different years

       

      Hi, I’ve a Pivot Table with two dimensions, years and months

       

      I need do the following: when I select the year dimension, not to summarize the months. Instead, I need get the maximum month per year.

       

      The problem is that i don't have the same periods for each year

       

      Ex:

       

      2010

      1,2,3,4,5,6,7,8,9,10,11,12

       

      2011

      1,2,3,4,5,6

       

      When i select Years dimension, max(months) returns me 12 and I need 2010/12 & 2011/6 selected, is it possible?

       

      I'm stopped here, I has been tryin with AGGR() and Set Analysis groups but i can't get the solution.

      Thanks a lot.