7 Replies Latest reply on Mar 1, 2019 5:16 AM by Zhouyi Zhang

    Top 5 Rank on Measures & Totals on Top 5

    Maria Damianova



      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