6 Replies Latest reply: Mar 5, 2013 4:25 AM by markvandermeij RSS

    Cumulative calculation with set analyses, ignoring selection (example included)

      Hi,

       

      I'm trying to generate cumulative results over the total period of time, even if there are some selections made.

      For example. if the user selects the last 3 weeks of a year, I still want to see the total value over all time.

      The user shuold be able to make other selections though, like on article level.

       

      I

      weekvaluecumm value
      2012.w521010
      2013.w11020
      2013.w21030

      in the above selection, if the user selects week 2013.w1 & week 2013.w2, the cumm value should still be 30.

       

      An example file with data and selections is included.

      Who can help? Thanks a lot!