Calculate sum for a set vs group

0 votes
How to display the sum of values in a set and group? What is the difference between them while showing Sum of values?
Jun 17, 2019 in Tableau by rahul
737 views

1 answer to this question.

0 votes

Hi Rahul,

You can only show the sum of set elements in an in/out level, not at a field level.

Whereas in a group even Groups or sub groups can show sum of field values. This is one main difference between group ans set and the other being Group is a static and a set is dynamic.

Sub total /groups total - 

Grand total - 

Hope it helps!

answered Jun 18, 2019 by anonymous
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,799 views
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17, 2019 in Tableau by Cherukuri
• 33,030 points
941 views
0 votes
1 answer

Combined set for dynamic selection of members in a set

Hi Priyanka Follow the below steps: 1. Create 2 ...READ MORE

answered Jun 12, 2019 in Tableau by anonymous
• 33,030 points
677 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
6,855 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,891 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,594 views
+2 votes
1 answer
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1, 2019 in Tableau by Cherukuri
• 33,030 points
980 views
0 votes
1 answer

Set default value for a filter

Hi Banu, It is easy and simple. Follow ...READ MORE

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,030 points
4,099 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