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