Show sales of last 12 months in a table

[PepeMontes]

Hello Deart Experts,
I want to show the last 12 months of sales From today(12-Aug-2019) in a table like this

MonthYear	Sales
September 2018	x
October 2018	x
November 2018	x
December 2018	x
January 2019	x
February 2019	x
March 2019	x
April 2019	x
May 2019	x
June 2019	x
July 2019	x

I'm using the next set analysis:
(Sum(Sales)/Sum({$< MonthYear= {$(=Month(Date#(Max(MonthYear)-1 'M')))}>} [Sales])) 

But this function just give me the last month and all the other stay null.

If someone can help me it would be great.

Regards.

JAMM.

[sunny_talwar]

Why do you have Sum(Sales)/Sum({<set_analysis>}Sales)? This would essentially give you NA or 1?

[PepeMontes]

Because i want to calculate the next funtion:
Balance/Sales(Last 12 months)

[sunny_talwar]

Would you be able to provide a sample where we can see the numbers you have and the output you expect to see from it?

[PepeMontes]

In the next image attached you would see that the only month filled it's April, because the set analysis of Date it's this one:
(Sum(Sales)/Sum({$< MonthYear= {$(=Month(Date#(Max(MonthYear)-3, 'M')))}>} [Sales]))

I know my set analysis it's wrong because i just calculating for the max month less 3 in this case April

I would like to have this information filled in the last 12 months, like a shown into the table of my frist comment.

Regards.