Forum Discussion

Anshenterprices's avatar
Anshenterprices
Icon for Helper IV rankHelper IV
4 years ago
Solved

Calculate Ranking and percent ranking


Hi Team.

 

DateCategoryOnline offline1DaySalesRankpercent rank
4/6/2021EquityOnline1234100
4/6/2021EquityOnline345375
4/6/2021Equityoffline567250
4/6/2021Equityonline789125
4/6/2021Commodityonline4532100
4/6/2021Commodityoffline564150
4/6/2021Currencyonline2341100
4/5/2021Equityonline256375
4/5/2021Equityonline04100
4/5/2021Equityonline345250
4/5/2021Equityoffline754125
4/5/2021Commodityonline6831100
4/5/2021Commodityonlinenull  
4/5/2021Currencyonline2463300


I want to calculate rank and percent rank

In report i have slicer Date, Category, Online offline 

Ranking is based on 1daysales by the selection of date and category 
percent rank forumula= ranking*100/counta(1daysales)

Note :- if its blank dont assign rank and percent rank also once i select online or offline category slicer, dont want seperate raking and percent rank , it should be same in both ways.

Need Help
Show and Tell
Tips and Tricks