New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Why does my Top 10 customers list barely move after I filter to one city?
What you'll have at the end
A Top 10 filter that reflects the city filter, using a context filter to force Tableau to apply the city first.
You need
A Tableau workbook connected to a customer sales data source, with a worksheet that already ranks customers by total sales and a City field you can filter on.
Not covered
A calculated-field workaround that reproduces this ranking with a formula instead of the built-in Top N filter; that's a heavier technique worth reaching for only when a context filter alone can't express the dependency between two filters.
Leans on
Percent-of-total math breaks once a filter narrows the view, unless the LOD is FIXED
Reach for this one when a filtered view's percent-of-total math goes wrong instead of a Top N list; the same order of operations, involving a FIXED calculation instead of a ranking filter, is the cause there too.
Turn a slow live dashboard into a fast extract
Reach for this one if the context filter's own recompute cost turns out to be what's actually slowing the dashboard down, since an extract changes that cost at its root.
Checked 26 Aug 2026
Part of the Tableau cookbook