Hi Team.
| Date | Category | Online offline | 1DaySales | Rank | percent rank |
| 4/6/2021 | Equity | Online | 123 | 4 | 100 |
| 4/6/2021 | Equity | Online | 345 | 3 | 75 |
| 4/6/2021 | Equity | offline | 567 | 2 | 50 |
| 4/6/2021 | Equity | online | 789 | 1 | 25 |
| 4/6/2021 | Commodity | online | 453 | 2 | 100 |
| 4/6/2021 | Commodity | offline | 564 | 1 | 50 |
| 4/6/2021 | Currency | online | 234 | 1 | 100 |
| 4/5/2021 | Equity | online | 256 | 3 | 75 |
| 4/5/2021 | Equity | online | 0 | 4 | 100 |
| 4/5/2021 | Equity | online | 345 | 2 | 50 |
| 4/5/2021 | Equity | offline | 754 | 1 | 25 |
| 4/5/2021 | Commodity | online | 683 | 1 | 100 |
| 4/5/2021 | Commodity | online | null | | |
| 4/5/2021 | Currency | online | 246 | 3 | 300 |
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.
