How to calculate last3months distinct outlet coverage

[#1]

Hi,

I want to show Last 3months distinct outlet coverage in text object.For Month-wise outlet count is coming correctly in my application.

Can any one know How to calculate Last 3month distinct outlet coverage.

Regards,

ba

[#2]

Hi,

Use the expr like this in ur textobject

=sum({<MonthNo={2}>+<MonthNo={3}>+<MonthNo={4}>}  DISTINCT Outlet)

[jagan]

Hi,

Use this expression

=Count({<DateFieldName={'>=$(=AddMonths(Max(DateFieldName), -2))<=$(=Max(DateFieldName))'}>} DISTINCT outlet )

In above expression replace DateFieldName with your date field name.

Hope this helps you.

Regards,

Jagan.

[#4]

Hi Sweth and Jagan,

Thanks for ur reply,

Can u please explain these in detaily.I used this expresion but it is showing some error.

thanks,

regards,

ba