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

    Show grand total for top N customers

    Torben Deuker

      Hi,

       

      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:

      Superstore.PNG

       

      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?

       

      Best,
      Torben