Board Thread:General Discussion/@comment-27798333-20160613032425/@comment-25956839-20160730101921

User:RR3 Michael P/Sandbox23 updated.

Instead of 8 separate tables, one for each category, a category field could be added, abbreviated A, N, PA, etc, as multiple filters are allowed. Although if you filter on one field, it does not recalculate the filter on another. So if you filter on event: NASCAR, you can then see the filter for Series:PSC which doesn't have any NASCAR events. I don't know what would be involved in coding that, I think sorting the filter would be a good start :)

I'm working on the remaining categories, probably be a week to finish, as I'm creating it with a PowerQuery in Excel, which will allow it the be updated quickly, so is time consuming to setup each series, but worth it in the end.

The code is almost identical for filter and sort, the data is the same, so two all series tables could be created, on two pages, one that can be filtered and the other sorted.