How to use RangeSum and sort colunm

[#1]

Hi,

How to use RangeSum and sort colunm?

I would like to sort the column "total", but when i use rangesum i can not.

Follow example;

[Nicole-Smith · Accepted solution]

What about sort on dimension day by expression =sum(value).

I've attached your example with it sorted.

[#3]

Nicole, its a great solution. But i can not use interactive sort, in my case i have many columns the totals, for example: 1 full, 2 full, avg ...

is there another way to do this?

[Nicole-Smith]

If you're allowing the user to sort the chart, it is going to change the values of the rangesum() calculation depending on how the chart is sorted.  You may want to look into calculating the rangesum() in the load script instead.