Aggregate Function with Trends

[Anonymous]

Hi

I would like to create a chart with Monthly Trends and the calculation requires and Aggregate function to return desired results.

I want to view months before and including selected months, however as soon as I use aggr() in the expression, this capability is broken and I only see the selected month. Is there a way to do this without having to aggregate data in the back end?

Please see attached qvw

[sunny_talwar · Accepted solution]

Apply the inner aggregation set analysis to the outer aggregation also to fix this issue

Avg({<Month={"<=$(vMaxMonth)"}>} Aggr(Avg({<Month={"<=$(vMaxMonth)"}>}Sales),Month,Company))

[Anonymous]

Hi Sunny

Thanks for your reply, It works perfectly