Showing the values of last 12 months

[#1]

how to show the sales of last 12 month(fiscal year) when i select august 2011?? i.e i want to see sales from july to aug(2010-2011)

[john_duffy]

Hello.

You can use a set analysis statement something like:

Sum({1<[Data Date] = {>=$(=date(addmonths(monthstart(makedate([Selected Year],[Selected Month])),-11))) <$(=date(addmonths(monthstart(makedate([Selected Year],[Selected Month])),+1))) Cntr

Note: synatx not verified.

John.

[jagan]

Hi,

Try this expression

=Sum({<DateField={'>=$(=MonthStart(Max(DateField), -11))<=$(=Max(DateField))'}>} Sales)

Replace "DateField" with your dimension name.

Hope this helps you.

Regards,

jagan.