How do I get the previous MonthYear on a chart?

[#1]

Thank you for helping me get the current MonthYear on the chart. I thought that getting the previous MonthYear would be quite straighforward once getting the current one was established, but it isn't.

It is the MonthYear from one year ago that I'm trying to get and I'm putting it in the second column of the aggr pivot table next to the current MonthYear.

I have managed to get the previous MonthYear to show in a text box, but if I put that exact formula inside quotes in the expression then I just get zeroes.

I can't figure out why this isn't working. Anybody know why?

[sujeetsingh]

Inthe text box you can get previous month as

=(Date(monthstart(max(Date)-365) -1, 'MMM-YYYY') )

[#3]

The text box gives me what I want no problem, it's the expression in the chart where I can't get it to work.

[#4 · Accepted solution]

Apart from a couple of syntax errors, you also have to undo the Year and Month filters, to have values for the last year in your expression. Try this one:

sum({$<MonthYear = {'$(=Date(monthstart(max(Date)-365), 'MMM-YYYY'))'}, Year=, Month=>} LineSalesAmount)

Juan Gerardo

[#5]

Thank you, it works.