I have a table as follows:
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.