Sum two columns together in Tableau

0 votes

how to find sum two columns together in Tableau?

Mar 18 in Tableau by Anitha
785 views

1 answer to this question.

0 votes

Hi Anitha,

 You can find sum of two fields using calculated field, but both the  number format should be same to provide correct answer,

For example, 

  • sum = [Sales] + [Profit] 
  • sum = SUM([Sales]+[Profit])
  • This follows for both numbers, decimal numbers, %'s.

Hope this helps you.

answered Mar 18 by Cherukuri
• 25,900 points

Related Questions In Tableau

0 votes
1 answer

Calculation issue: Distinct sum in Tableau

SUM( { FIXED [Brand], [Market]: AVG(Target) } ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,240 points
2,451 views
0 votes
1 answer

How to add filter to show latest two dates in tableau?

Steps for filtering based on the most ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
32 views
0 votes
1 answer

How can I remove { } from columns in Tableau?

Create the following calculated field and use ...READ MORE

answered Aug 9, 2018 in Tableau by Atul
• 10,240 points
55 views
0 votes
1 answer

Aggregating from multiple columns in Tableau

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Aug 17, 2018 in Tableau by Atul
• 5,530 points
236 views
0 votes
1 answer

Sum Filtered Data in Tableau

Hi Anitha, Its quite simple, To use a ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 25,900 points
360 views
0 votes
1 answer

How to compare two columns and sum the values that are same/equal?

Hi, Try like below, IF [COL1] = [COL2] THEN ...READ MORE

answered Jun 12 in Tableau by anonymous
• 25,900 points
43 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,814 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
589 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 25,900 points
488 views
0 votes
1 answer

How to make two parameters dependent in tableau?

Hi, 2 parameters are dependent when one ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 25,900 points
185 views