Calculate Ranking and percent ranking

[Anshenterprices]

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.

[amitchandak · Accepted solution]

@Anshenterprices , Please find the attached file after signature. The last row is a bit different 

Check the table in data view

[Anshenterprices]

Awesome ! @amitchandak  Thank you so much