Forum Discussion

Sajid02's avatar
Sajid02
Icon for Helper I rankHelper I
3 years ago

How to get ranking

Hi Folks, Need help on the ranking formula . As per the need :-  1. We need to show ranking as per Product and price from higher to lower i.e higher value should be 1 and then goes on .... 2. We...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
3 years ago
rank = RANKX( FILTER( data, AND( data[Product] = EARLIER(data[Product]), data[City] = EARLIER(data[City]))), data[Price], , Dense)
--Try this one hope it works
Sajid02's avatar
Sajid02
Icon for Helper I rankHelper I
3 years ago

MH 

Hi , 

This is not working as passing more than 2 argument in filter function is not accepting 

Snip