How can read last 8 months data

[#1]

I Want to display a last 8 months data in the expression using SET analysis.

[its_anandrjs · Accepted solution]

Write like

=Sum({$<MonthYear = {">$(=num(AddMonths(today(),-9))) <=$(=Num(addmonths(today(),-1)))"}>} YourSalesValue)

[#3]

Can i used it for any Dimension like months and monthname.

[its_anandrjs]

Yes you can use it for any expression or dimension.

[#5]

I want to use variable in place of the formula in expression.

[its_anandrjs]

Create two variables like

vStart  =num(AddMonths(today(),-9))

vEnd =Num(addmonths(today(),-1))

And then use script like

=Sum({$<MonthYear = {">$(vStart) <=$(vEnd)"}>} Sales)