How to show Subtotal for groups?

0 votes
How to show Subtotal for groups? How to show sub total for subcategory for each category?
May 21 in Tableau by Anitha
18 views

1 answer to this question.

0 votes

Hi Anitha,

You can form groups in tableau manually or by selecting items from the visual.

By selecting on the visual -> 

Select the group of items then click on the group icon.

Now Edit the groups and items within them.

Now place the group in the visual, and also the items in the group on the shelf.

From field ->

Now go to analytics pane and drag the totals and place in sub-totals followed by grandtotals.

Hope it helps.

answered May 21 by Cherukuri
• 28,360 points

Related Questions In Tableau

0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
60 views
0 votes
1 answer

How to change months for a calendar year

Hey, you can try this & Change ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
25 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 28, 2018 in Tableau by Atul
• 10,240 points
46 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
903 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
2,082 views
+1 vote
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
92 views
+2 votes
1 answer
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 in Tableau by Cherukuri
• 28,360 points
54 views
0 votes
1 answer

How to find first n months profit/sales for a given year

Hi Sindhu, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 28,360 points
29 views