2 Replies Latest reply on May 10, 2018 7:13 AM by Zhouyi Zhang

# Help with Calculated Field and Subtotals

Hello,

I am a relatively new user to Tableau. I need help with what is normally a simple calcuation in Excel.

As you can see below, I am trying to calculate the attainment by using the following formula: [Total Gross]/[Dir Quota]

The calculation is working correctly at the summary level, but not in the subtotal level. \$213,499 / \$363,840 = 58.7%, however the calculation is showing 177.5%, which is the sum of the calculations below.

• ###### 1. Re: Help with Calculated Field and Subtotals

Hi Ray

First welcome to Tableau

if you are using a simple calculation then open the green pill- go to total using and select how you wan the totals to work

see below

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Help with Calculated Field and Subtotals

Hi, Ray

I think you need use LOD to calculate, can you provide a sample workbook?

ZZ