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 17, 2018 in Tableau by ghost
• 1,790 points
44 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 17, 2018 by Atul
• 5,530 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 16, 2018 in Tableau by Atul
• 5,530 points
50 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 in Tableau by Cherukuri
• 28,280 points
53 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
162 views
0 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
90 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 Atul
• 5,530 points
81 views
0 votes
1 answer

Calculation issue: Distinct sum in Tableau

SUM( { FIXED [Brand], [Market]: AVG(Target) } ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,240 points
2,684 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 Atul
• 5,530 points
45 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 Atul
• 5,530 points
109 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 Atul
• 5,530 points
37 views