Hi people!
I really need some help here.
below is an example of what i want to achieve.
| year | Ingoing Balance | recoded amount |
| 2017 | 600 | 100 |
| 2016 | 800 | -200 |
| 2015 | 500 | 300 |
| 2014 | 800 | -300 |
| 2013 | 300 | 500 |
| 2012 | 200 | 100 |
| 2011 | 0 | 200 |
I want to sum the recorded amount of all the previous years and put in the present years "Ingoing balance" column (so for year 2017, sum recorded amount until 2016), BUT i do not want the values in this column to be affected by any selections....
I have tried Set analysis but I did not get it to work properly.
Here is what I have tried so fara:
RangeSum(above(Sum({1<[Year]>} [Recorded amount]), 1, [Year] ))
I think would like to make the entire expression a set...
I am super grateful for any suggestions!
Thanks!
