Sum two columns together in Tableau

0 votes

how to find sum two columns together in Tableau?

Mar 18, 2019 in Tableau by Anitha
2,203 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, 2019 by Cherukuri
• 32,440 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,250 points
3,259 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,250 points
56 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,250 points
78 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
767 views
0 votes
1 answer

Sum Filtered Data in Tableau

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

answered Mar 13, 2019 in Tableau by Cherukuri
• 32,440 points
1,032 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, 2019 in Tableau by anonymous
• 32,440 points
81 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,250 points
2,667 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,820 points
1,115 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, 2019 in Tableau by Cherukuri
• 32,440 points
1,298 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, 2019 in Tableau by Cherukuri
• 32,440 points
493 views