Choose Language Hide Translation Bar
Community Trekker

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

0 Kudos

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.