aggr function - Taking more time

[#1]

Hi All,

I am using below code in my combo chart to calculate YTD Average.

Dimensions: DEPT,PRODUCTTYPE

Selection: MONTH,YEAR

aggr(RangeAvg(Above( sum({<Year={$(=Max(Year))}, MONTH>}SALES),0,RowNo())),DEPT,PRODUCTTYPE,MONTH)

/

aggr(RangeAvg(Above( sum({<Year={$(=Max(Year))}, MONTH>}VOLUME),0,RowNo())),DEPT,PRODUCTTYPE,MONTH)

Issue: Application is hanging showing green color loading button when I select MONTH.

Please help me in fine tune the expression.

Thanks in advance.

[sunny_talwar]

I would suggest using The As-Of Table‌ instead RangeSum(Above()) to improve performance here.

[#3]

Hi Sunny,

Could you please help me with the code. How to do that.

I need to calculate YTD AVERAGE.

Thanks in advance.

[sunny_talwar]

Not sure what the expected output is, but can you check the attached