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
Go to the sorting field in the setting bring Rank columnup so it will sort according to that if you have sorted the data by customer name Ranks will not be in order.