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.