title: Dynamic Sorting in Tableau Table
body: <p>I am new to Tableau and one of my tasks if to show top 10 brands.</p>
  <p>I have 3 columns: Profit, Sales, and NPS.</p>
  <p>The data looks something like this:</p>
  <h2>| | Profits | Sales | NPS |
  | --- | --- | --- | --- |
  | Nike | 10m EUR | 32m EUR | 0.91 |
  | Adidas | 6m EUR | 21m EUR | 0.88 |
  | Levi | 12m EUR | 27m EUR | 0.94 |</h2>
  <p>I know how to select Top 10 brands based on Profits or Sales or NPS individually, but how do I make it so that when the user sorts by Profits it gets top or lowest 10 profitable brands based on sort type (ascending or descending). Similarly the same for Sales and NPS.</p>
  <p>Outcome when sorting by Profits (desc):</p>
  <h2>| | Profits | Sales | NPS |
  | --- | --- | --- | --- |
  | Levi | 12m EUR | 27m EUR | 0.94 |
  | Nike | 10m EUR | 32m EUR | 0.91 |
  | Adidas | 6m EUR | 21m EUR | 0.88 |</h2>
  <h2>Outcome when sorting by NPS (asc):
  | | Profits | Sales | NPS |
  | --- | --- | --- | --- |
  | Zignov | -23K EUR | 193K EUR | -0.85 |
  | R&amp;R | -94K EUR | 202K EUR | -0.74 |
  | Bumble | -133K EUR | 89K EUR | -0.69 |</h2>
  <p>Current Implementation: Right now, the dashboard displays top 10 brands by Profits, when I want to sort them by NPS, it resorts the same 10 brands, instead of from the complete dataset.</p>