How to ignore selection with aggr function

[gys1992infosys]

My measure is : sum(aggr(sum({<YR=,MO_DESC=,DY_CODE={'>=$(=Yearstart(Max(DY_CODE)))<=$(Max(DY_CODE))'}>}distinct BOTTLE_VOL_IN_HL+CAN_VOL_IN_HL+KEG_VOL_IN_HL),DELV_NUM)))

But it doesn't work , how to fix it .

[Thiago_Justen_]

Try this out:

sum({1}aggr(sum({<YR=,MO_DESC=,DY_CODE={'>=$(=Yearstart(Max(DY_CODE)))<=$(Max(DY_CODE))'}>}distinct BOTTLE_VOL_IN_HL+CAN_VOL_IN_HL+KEG_VOL_IN_HL),DELV_NUM)))

[gys1992infosys]

Hi Thiago,

Its working, but its directly to fixed the month selection, I want that I select May,the value is January to May,

Now is always January to MaxDate.

[fabdulazeez · Accepted solution]

Try putting it set Analysis both the outer and the inner aggregation function

[gys1992infosys]

Thanks, Its working!