Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm basically trying to show the sum of a measure for rolling 12 months. For some reason the set analysis is not evaluating properly.
When i select apr 2012, the graph should display from may 2011 to apr 2012
Any help is appreciated. i'm attaching the sample file for the same.
Your issue is your inconsistent date formatting. Set analysis respects date formatting so try this:
Sum({<MonthYear={">$(=Date(AddMonths(Max(MonthYear),-12),'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),0),'MMM-YYYY'))"}>} Attritiioncount)
Also, for some reason you can't have a space either side of the red bit!
Hope this helps,
Jason
Your issue is your inconsistent date formatting. Set analysis respects date formatting so try this:
Sum({<MonthYear={">$(=Date(AddMonths(Max(MonthYear),-12),'MMM-YYYY'))<=$(=Date(AddMonths(Max(MonthYear),0),'MMM-YYYY'))"}>} Attritiioncount)
Also, for some reason you can't have a space either side of the red bit!
Hope this helps,
Jason
Hi Jason, Thanks... worked like a charm.