Creating a calculated field for summing up the values

0 votes

What I have?:

 ----------------------------------------------
    ID  Name            Value                    |
    ---------------------------------------------|          
    1   Bob             4                        |
    2   Mary            3                        |
    3   Bob             5                        |
    4   Jane            3                        |
    5   Jane            1                        |
    ----------------------------------------------
 

What I want?

Is there any ways to do out a calculated field where if the name is "Bob" , it'll sum up all the values that have the name "Bob"?

May 18, 2018 in Tableau by ghost
• 1,790 points
459 views

1 answer to this question.

0 votes

Well you can use this in your calculated field

If Name = “Bob” then Value end
answered May 18, 2018 by ffdfd
• 5,550 points

Related Questions In Tableau

0 votes
0 answers

Creating a multiple charts with calculated field

Sample data: Table Name: A Mode Country Month Visitor ...READ MORE

Aug 17, 2018 in Tableau by ffdfd
• 5,550 points
393 views
0 votes
1 answer

Search values in a sheet for a field and display in tableau

Hi Sindhu, Follow below steps: 1. Create a parameter ...READ MORE

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,030 points
802 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
2,827 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,265 views
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
894 views
0 votes
2 answers

Calculation issue: Distinct sum in Tableau

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

answered Aug 26, 2020 in Tableau by Dhiraj Kumar Sahu
9,083 views
0 votes
1 answer

Error: Comaparing date value with YEAR in Tableau

You have to ensure that the comparisons ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
425 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

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

How can I add a row number for a specific field?

Hi @Noob, You can use RANK_DENSE function: "The function returns the ...READ MORE

answered Apr 17, 2018 in Tableau by ffdfd
• 5,550 points
1,196 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