BookmarkSubscribeRSS Feed

Community Trekker


Sep 29, 2014

Dynamic local Data Filter by jsl

Dear Pros,

I have a local data filter for character, which is "AgencyCode". The data table is changing every minute, as the reservations come in the related number of reservations with related AgencyCode is growing. We are in agreement with more than 200 Agencies which makes the tabulate very long and complex. Is there a way of dynamically selecting AgnecyCodes? Let's say "greater that 200", or "sorted by number of AgencyCode entries and first 80% Cumulative"...

Thank you for any help in advance

8619_Screen Shot 2015-04-22 at 15.05.33.png




Jun 23, 2011

Re: Dynamic local Data Filter by jsl

One approach would be to define 'super categories' via a formula column (which could involve any logic you care, given some dexterity with the formula editor). Then associate the local data filter with this new column. With some judicious naming, the data filter UI should be more manageable.