Forum Discussion

Advocate I

2 years ago

Solved

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 ...

BenediktW
2 years ago
lbendlin

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")

Advocate I

2 years ago

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")

Related content