Display values of previous year

[Anonymous]

Hi all,

I would like to display the values of the previous year in a specific format. I can't seem to manage to display the numbers as shown in the table below...Do you have any suggestions how to realize this?

Year	Month	Actual Value	Previous Year
2016	1	10	0
2016	2	20	0
2016	3	30	0
2017	1	15	10
2017	2	25	20
2017	3	35	30

It should be in such a way that when you filter on 2017 month 1, it should also display the same values...

Does someone has the experience to realize this?

Thanks in advance!!

[sunny_talwar]

What are you expressions that you are using right now?

[Anonymous]

Thanks for your reply!

Previous Year=SUM({$<Year={$(=MAX(Year)-1)}>}Value)

This gives a 0 for 2017 and only shows data for 2016

[sunny_talwar]

How about this

Aggr(Above(Sum({<Year, Month>}Value)), Month, Year)