I have 3 sheets where need to retain rank when filter is applied.
I have done it by adding LOOKUP(MAX([Customer Name]),0) in calculated field & use it in the quick filter
How to make it as global filter across all 3 sheets?
Hey Ram, check out the following post for an example of using a parameter to work around this issue:
Creating a Global LOOKUP(MIN(...),0) Filter with a Parameter for "Jedi" Filter and Table Calc Trick
Hope this helps!
Retrieving data ...