1 Reply Latest reply on Dec 15, 2015 7:41 PM by Adam Crahen

    Sum values of top N%

    jake long

      Hi, so im having trouble creating a sort of concentration index

       

      Currently i am trying to identify the top 8 customers and sum their profit value.
      After, i want to use this summed value of the top 8 and divide it by the total amount of profit of all the customers.


      I've managed to identify the top 8 customers using SET however unable to calculate their total, against the total of all customers

      currently my formula is: SUM([Profit])/TOTAL(SUM([Profit]))
      Which Produces:

       

      Capture.PNG

       

       

      Using the basic superstore Data sheet.
      Using TOTAL(SUM(PROFIT))
      Tableau only draws the total of the top 8 and the rest seperately,
      therefore im unable to properly divide and create a proper index.

       

      All help is really appreciated, and thank you in advance!!