Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I am using rank function it is working fine when clear all selections ,of I select month filter the order of the ranks are not getting in order .Below is the logic i am using
=Aggr(Rank(Sum(Sales)*0.55),[Customer Name])
Thanks,
Sateesh.T
Hi Satish,
Go to the sorting field in the setting bring Rank column up so it will sort according to that if you have sorted the data by customer name Ranks will not be in order.
Hope it works for you
Thanks