3 Replies Latest reply: Nov 25, 2013 4:45 AM by Mohit Sharma RSS

    Help in Set Analysis Expression

      Hi all,


      I created a table with some


      dimensions and three expressions(Sales,Recurring,%mix).

      The Recurring expression  values will be either 1 or 0.

      My '%mix' expression is



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


      In my '%mix' expression  second part i.e.Sum(TOTAL {$<YEAR = {$(=Max(YEAR)-1)} >} SALES) should act based on recurring value. It should only take 'total ' of those records  whose recurring value is '1'

      PS:Please find attached file for the table and its expressions.


      Please let me know how can i change my ' %mix' expression

      Any help would be appreciated.


      Thanks in advance.


      Best Regards,