5 Replies Latest reply: Nov 9, 2015 10:52 AM by Sunny Talwar RSS

    Progressive SUM, selection indipendent

    Luca V

      Hi,

      i have this table ( black font. I need to calcolate the RED one):

      YEAR     MONTH     MONEY     PROGRESSIVE

      2011          1               100               100

      2011          2               200               300            

      2011          3               200               500

      2011          4               400              900

      2011          5               300               1200

      2011          6               200               1400

      2011          7               800               2200

      .....          .....               ......

      2015          1               200               2200 + ....  + 200

      2015          2               300               2200 + ....  + 200 + 300

      2015          3               200               2200 + ....  + 200 + 300 + 200

      2015          4               800               2200 + ....  + 200 + 300 + 200 + 800

      ......          ......          .......

       

      I create a chart with:

      - DIMENSION :  MakeDate(YEAR,MONTH)

      - EXPRESSION: MONEY

       

      If in EXPRESSION I set "FULL ACCUMULATION"  i obtain PROGRESSIVE column but if i made TIME (month or year) selection the value of PROGRESSIVE change on the base of time filters.

       

      How can be possible obtain PROGRESSIVE values independently from filters ?

       

      Thanks