Help needed on Rolling 13 months with Aggr()

[#1]

Hi All,

Hope everyone is good.

I need your help with the rolling 13 months data with aggr ().

I have a  requirement like i need to display avg customer score for rolling 13 months. For that i have used Avg({<Year=,Month=,

Date={">=$(=AddMonths(Max(Date),-13))"}<=$(=Max(Date))>}Score). with the expression values are not coming correctly as the customer code is repeated for multiple rows due to which the avg value is wrong.

Then i have changed the expression to include aggr () as below.

Avg(Aggr(Avg({<Year=,Month=,Date={">=$(=AddMonths(Max(Date),-13))"}<=$(=Max(Date))>}Score),CustomerID).

With the above expression i am able to achieve the correct value but i am not able to display rolling 13 months. The chart i am using is line chart.

Thanks in advance.

Regards,

Nani

[sunny_talwar]

I think it should work....

[#3]

Ok. I will modify the logic and test.