Forum Discussion
Cumulative Total Issue
Hello, When I want to make cumulative total for my table that you can see below, my formula returns wrong cumulative total for each distributor row. Can you help me to solve this issue ? (What I ...
Anonymous
Try:
RANKX % Sum ratio = RANKX(ALL(table[DistName]); [Sum Ratio]; ;DESC)Followed by:
Cumulative % Sum Ratio = SUMX(TOPN([RANKX % Sum ratio]; ALL(table[DistName]); [Sum Ratio]); [Sum Ratio])And to get rid of the total:
Cumulative without total in matrix = IF(ISINSCOPE(table[DistName]); [Cumulative % Sum Ratio]; BLANK())
Anonymous
Try:
RANKX % Sum ratio = RANKX(ALL(table[DistName]); [Sum Ratio]; ;DESC)
Followed by:
Cumulative % Sum Ratio = SUMX(TOPN([RANKX % Sum ratio]; ALL(table[DistName]); [Sum Ratio]); [Sum Ratio])
And to get rid of the total:
Cumulative without total in matrix = IF(ISINSCOPE(table[DistName]); [Cumulative % Sum Ratio]; BLANK())