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,421 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,185 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,092 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 • 1,006 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 • 904 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,892 views
+2 votes
1 answer

How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 3,518 views
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,594 views
+2 votes
1 answer

How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 9,887 views
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,536 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,080 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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.