Yes very much agreed, some sort of RANKING function within an LoD would be very handy...here's the idea so get voting! https://community.tableau.com/ideas/4553
With regards you problem, I've not opened your workbook (only got 5 mins!)...but in order to get filters to affect LoDs you need to make the filter 'in context' (add to context option you'll find in the filter options). FIXED LoDs are calculated before 'regular' Dimension filters are added, but by 'adding it to context' you 'bump' the filter up the calculation pipeline (here's a link to the whole pipeline Vizible Difference: Evolution of the Order of Operations Diagram , which in many cases is very useful...such as using Table Calc filters)
So hopefully this solves you issue (...and well in time for Xmas!!), but if not let me know and I'll take a proper look at your workbook when I have a bit more time
Doh! I'm going for a donut... AWESOME-- THANK YOU. You know there are times when you're so focused on one direction, that you never think to look up!
Thanks Simon! Works like a charm! ----And you didn't even need to look! Too cool!
No problem...I'm the king of not 'seeing the wood from the trees'!!...many a time I've ended up with some super-complicated multi-layered, nested Table calculation arrangement...only for someone to point out...yes that's very clever, but isn't that just SUM([Number of Records])