3 Replies Latest reply: Apr 23, 2015 1:21 PM by PAUL YEO RSS

    How to change my SET analysis to become accumulated ?

    PAUL YEO

      Hi All

       

       

      I have SET analysis as beow working fine :-

       

       

      sum({$<           year=,          month=,           MonthSeqNum = {$(=only(MonthSeqNum)-12),$(=only(MonthSeqNum))} >}  sales/1000)

       

       

      When i click month = 1 the amt display 546

      When i click month = 2 the amt display 826

       

       

      May i know how to modify the above expression , so that it will behave as below :-

       

      When i click month = 1 the amt display 546

      when i click on month = 2 so it display as 546 + 826 = 1372 ?

       

       

      Paul