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

0 votes
How to compare two columns  and sum the values that are same/equal?
May 23, 2019 in Tableau by Anitha
1,411 views

1 answer to this question.

0 votes
Hi,

Try like below,

IF [COL1] = [COL2] THEN [COL1] + [COL2] END

Hope it helps!
answered Jun 12, 2019 by anonymous
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by ffdfd
• 5,550 points
1,143 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
3,070 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 29, 2018 in Tableau by Atul
• 10,240 points
983 views
0 votes
1 answer

How to return the string between 5th and 6th Spaces in a String

In Tableau 9 you can use regular ...READ MORE

answered Jun 27, 2018 in Tableau by ffdfd
• 5,550 points
885 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
9,839 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

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

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
5,485 views
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
1,051 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP