Forum Discussion
Visual calculation: running sum - sorting issue
Hello together,
I ve tried to utilize the new visual calculations to calculate running sums (cumulative percentage sales per customers as running totals).
Anyhow, I have the problem that the running sum gets calculated based on the alphabetical order of the category. Not on the sales volume (how I want it to be), on which the table is sorted. Is there any solution for this?
Thank you very much!
On the "Anteil_am_Gesamtumsatz" you can see the correct order. Anyhow the running sum is not calculating based on the sorted order but on the alphabetical order of my category.
20 Replies
FINALLY!! THANK YOU!!! I have been searching for HOURS for this solution. I cannot believe it's this complex to change the sort order. THANK YOU, THANK YOU, THANK YOU
We want to change this and are working through options here. What would you like to have seen?
you can now do this with just runningsum (and without format): RUNNINGSUM([Sales], ORDERBY([Sales], DESC)). Then format the visual calculation using the data formatting option.
Since July, you can do the same using just RUNNINGSUM with the OrderBy parameter
please show the visual calculation formula
That is the formular for running sum
My visual is sorted like this (based on Sales):
However, as soon as I enter the visual calculation area, it automatically ignores the sorting of the table and just takes the alphabetical order of my category (Customer):
no, right now, just like with a window function you dicate the exact sort order. We have not gotten around to making this responsive to however the visual is sorted.
