4 Replies Latest reply on Feb 6, 2019 5:20 AM by Alyn Still

    Top 5 Rank on Measures & Totals on Top 5

    Maria Damianova

      Hi,

       

      my data set consists of 1 dimension (product) and 10 measures ( types of defects). I would like to create a Top 5 defects rank, and then add a grand total at the bottom of the table ( for each column)  to show total defects for those Top 5 defects.

      It seems fairly simple, however, I can't create Top 5 data set with measures in Tableau. Furthermore, I can't add a Grand Total for each column because the rows are measures, so I have to create a calculated field to sum up the Top 5 defects. Since the Top 5 defects can change, creating a calculation to sum up those specific measures is not ideal.

       

      Any ideas how I can accomplish this?

       

      Thanks, Maria