App Development

[Lital]

Hi,

I would like to create a Bar Chart with  dimension Year  and a measure showing the previous year  sum of  [Value]  meaning  sum({ previous year} [Value])

for example I expect to see for 2019 bar the sum for 2018, for 2018 bar the sum for  2017 and so on. 

I tried many options, but it doesn't work well.
the same worked for me before with other dimensions.

how can this be done? 

*I actually need to display the change percentage between the year and the year before,   i was trying to simplify the issue.   

Thank you!

[martinpohl]

That's right, the expression only shows previous value.

But you can add actual value.

See example

and the value in column 2 in above-expression is december value