Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.