Sum two columns together in Tableau

0 votes

how to find sum two columns together in Tableau?

Mar 18, 2019 in Tableau by Anitha
6,548 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,490 points

Related Questions In Tableau

0 votes
2 answers

Calculation issue: Distinct sum in Tableau

I feel the easiest way is to ...READ MORE

answered Aug 25 in Tableau by Dhiraj Kumar Sahu
5,065 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
135 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
146 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,540 points
2,895 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,490 points
3,264 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,490 points
141 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
4,854 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
2,010 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,490 points
5,103 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,490 points
1,935 views