7 Replies Latest reply on Aug 24, 2017 5:03 AM by pavan hm

    Show grand total for top N customers

    Torben Deuker



      what if someone asks "How much profit do we make with our top 5 customers?" and you want to have an easy viz giving the answer?


      E.g. in superstore I create this:



      Showing the top 5 customers (ranked) by profit. As you can see, the Grand total still shows the unfiltered value for all customers. Is there an easy way to only show the value of those top N people, so their sum?

      I'm using Tableau 10.3 and this is not specific to any dataset, so I just built it using the sample. I know it is related to the fact that totals are calculated before table calculations (like rank) in the order of operations.


      Do you have an idea?