6 Replies Latest reply: Jan 31, 2017 9:06 PM by Lokesh Patel RSS

    Set analaysis within set analysis

    Lokesh Patel

      Hi guys,

       

      I have loaded following inline table so that I can use it as a filter.

       

      Rolling
      R3
      R6
      R12

       

      I am using following expression in one of my chart

       

      =Num(Sum(Sales) / Sum(TOTAL <SalesRep> {<Product>} Sales),'0.0%')

       

      I would like the above expression to change based on the selections made in the Rolling field


      • if R3 is selection then it should only show sales for last 3 months from the max SalesDate in the database
      • if R6 is selection then it should only show sales for last 6 months from the max SalesDate in the database
      • if R12 is selection then it should only show sales for last 12 months from the max SalesDate in the database

       

       

       

      What is the best IF statement or Set Analysis to achieve that?

       

      Thanks