Aggr and Set analysis for YoY analysis

[sravankv]

Hi All,

I have a report which should show year over year analysis for selected month.

below formula works perfectly fine i.e. selected moth and all previous year from selected year.

Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
[Aging Hours])

But, when i apply aggr to above formula it is showing only selected moth and year(not giving data for previous years).

=Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
			Aggr(sum([Aging Hours]),Number,State,Group,Name))

appreciate your support in resolving.

Regards,

Sravan

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

=Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
Aggr(sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}[Aging Hours]),Number,State,Group,Name))