Forum Discussion
BenediktW
Advocate I
Advocate IVisual 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 ...
BenediktWAdvocate I
Advocate I
Finally I found a solution without runningsum but with visual calc, which is working properly:
FORMAT(SUMX( WINDOW(1, ABS, 0 ,REL, ALLSELECTED([Customer, ], [Sales]), ORDERBY([Sales], DESC
)), [Share total Sales]) , "Percent")
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
- jeroenterheerdt
Microsoft Employee
We want to change this and are working through options here. What would you like to have seen?
- Lajouac
Hi jeroenterheerdt !
I am very happy to have found this solution !
I would have imagined an ORDERBY parameter inside the running sum function, in able to choose the column to use to order the running sum.
Thanks for working on this !- jeroenterheerdt
cool, because that's exactly what I was thinking 🙂
