0 Replies Latest reply: Nov 21, 2013 4:12 AM by Senthil Kumar RSS

    Adhoc Reports - How to use set analysis in Expression

      Hi All ,

       

      I have a scenario in which the following set Analysis has to be used in Adhoc Reporting

       

      Sum({$<YEAR = {$(=Max(YEAR)-1)}>} VOLUME)

       

      I have 2 Table : Dimension , Measures

       

      Dimensions are

      CHANNEL

      REGION

      COUNTRY

       

       

      Measures are

      YTDN-1

      etc

       

      How can i add the above set analysis in a way that it works in Expression for Adhoc Reporting?

       

       

      Thanks