Display previous month data

[aleksas_baltpool]

Hi,

I'd like to have a column that shows data from a previous month. Tried doing this with set analysis however with no luck.

Script regarding this table looks like that:

I'm using hau_month as a dimension in the chart. I'd like to display sum(hau_total_amount) for the current and for the previous month. 

Tried something like that: sum({<hau_month={$(=Max(hau_month)-1)}>}hau_total_amount)

However the result is zeroes. Hope you can help me with it !

[aleksas_baltpool]

Is it possible to get data from two months ago using some kind of formula like that?

[tresesco · Accepted solution]

Above(sum(hau_total_amount), 2)

[aleksas_baltpool]

Great, thanks!