Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Cod | Store | Rank |
17459 | 382.866,50 | 9,00% |
5277 | 315.619,78 | 7,42% |
19197 | 73.198,66 | 1,72% |
24542 | 66.645,75 | 1,57% |
23283 | 62.226,76 | 1,46% |
I need to accumulate Rank like the example below.
set analysis
Cod | Store | Rank |
accumulated
|
4.252.486,56 | 100,00% | ||
17459 | 382.866,50 | 9,00% | 9,00% |
5277 | 315.619,78 | 7,42% | 16,43% |
19197 | 73.198,66 | 1,72% | 18,15% |
24542 | 66.645,75 | 1,57% | 19,71% |
23283 | 62.226,76 | 1,46% | 21,18% |
@Paula1 is the Rank expression ? If so what is expression?
As below
=Rangesum( Above( Aggr (
<EXPRESSION FOR RANK>
,COD),0,rowno()))
@Paula1 is the Rank expression ? If so what is expression?
As below
=Rangesum( Above( Aggr (
<EXPRESSION FOR RANK>
,COD),0,rowno()))