1 Reply Latest reply on Apr 25, 2018 10:38 AM by Deepak Rai

    How to sum up attribute values?


      Hi there,


      I have a table as follows:


      AccountProject IDANCTEmployee
      A12345 $       100 David
      A12345 $       100 Susan
      A12345 $       100 Charles
      A23456 $       300 Tom
      A23456 $       300 Ming
      B34580 $         50 Susan
      B34580 $         50 Juno
      B56801 $       500 Tom


      Each project should have a constant ANCT. E.g. 12345's ANCT is $100.

      I'd like to create a table for calculating the total of ANCT per account. The result should be:


      For account A, the total ANCT should be $400 while account B should be $550.


      How can I sum up the ANCT per account in Tableau as it'll give me $600 for account A and $900 for account B. Thanks.