4 Replies Latest reply on Nov 19, 2018 6:34 AM by Bren Perkins

    Total of Top 'N' Selected by Parameter

    Bren Perkins

      Hi all, I'm hoping someone can help me out.  I've created a Parameter letting the user enter a number to show the top 'N' subcategories by sales.  The issue I'm having is that I want to make a dynamic KPI tile which will only display the total sales of the top 'N' subcategories selected.  For instance, the sum of the top three sub-cats is $882,300 (which should be shown if a '3' is keyed) while the total of the top five sub-cats is $1,292,679 and should be shown if a '5' is keyed.  If someone can give me some help I'd really appreciate it.

       

      I'm using Tableau 10.5.2 and I'm including a workbook based on the Sample - Superstore data.  Thanks, and all the best!

       

      Bren