How get the right value in Ingoing balance

Thu, 16 Mar 2017 12:23:29 GMT

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!

topic How get the right value in Ingoing balance in App Development

How get the right value in Ingoing balance