SUM 2 columns when the value of the third column is DISTINCT

0 votes

Hello everyone,

I have a dataset like this :

ID TAX SubTotal
1 10 2
1 10 2
1 10 2
2 5 3

I want a calculated field that can return for each distinct ID the sum of subTotal and Tax.

So I'll here get for ID = 1 a result of 12 and NOT 36.

Thank you all !

Feb 19, 2022 in Tableau by riri

edited 5 days ago 6 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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