Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ranking For few columns

Hi  I have a sample below table, which i hav the data this way. Productname Subcategory revenue Coolers homecooler 345 Refregirator Mini refregiration 543 Fulltotal Total 456 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous Try:

Column = 
    VAR __Count = COUNTROWS('Table5')
RETURN
    IF([Productname]="Fulltotal",__Count,RANKX(FILTER(ALL('Table5'),[Productname]<>"Fulltotal"),[revenue],,DESC))

Column = 
    VAR __Count = COUNTROWS('Table5')
RETURN
    IF([Subcategory]="Total",__Count,RANKX(FILTER(ALL('Table5'),[Subcategory]<>"Total"),[revenue],,DESC))