RangeSum(Above( performance issue, how can it be fixed?

[Davide_Azzolini]

Hi, 

I have a performance issue using RangeSum. 

Here the expression:

RangeSum(Above(
Sum({$<Year = {$(=If(GetSelectedCount(Year) = 0 AND GetSelectedCount(MonthYear)=0, max(Year), Concat(Year, ',')))}>} value_fact)
, 0, RowNo()))

When I change filters, charts and tables takes too long to load the filtered data.

I tried to put RangeSum into the script, but it isn't what i want, I need a runtime calculation of that column. 

The question is: 

Do I need to upgrade my server to make rangesum faster? 

Thanks to all, Davide.

[sunny_talwar · Accepted solution]

Use The As Of Table instead

[Davide_Azzolini]

Very useful, thanks!