3 Replies Latest reply: Jul 11, 2011 5:27 AM by Bhaskar Reddy RSS

    Need to show 3 months data in a selected month

      Hi all,

       

      Please help

       

      I need to develop a pivot chart in which I have show 3 months data for a selected months.

      for example if user select jan, then output should be of Jan,Dec and Nov

       

      I have used Month as my dimension and written an expression as sum({<currentmonthstart={'>=(=Addmonths(Max(currentmonthstart),-2))'}>} Call_Ref_Num)

      which is not working properly.

       

      Also want to know whether can we use column() function in set analysis?

      Ex: sum({<Region={'US'}>} Column(1))

       

       

      Please suggest.

       

      Thanks in advance.