Subscribe Bookmark RSS Feed

Dynamic local Data Filter by jsl

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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

1 REPLY
ian_jmp

Staff

Joined:

Jun 23, 2011

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.