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










      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.