How to add grand totals of the bar in Stacked Bar in Tableau

+1 vote

I have created a stacked bar and included 'Row Grand Totals' to the view, further to this have made use of 'Add Reference Line' option and brought Grand Totals for each of stacked bar. But could not bring Grand Totals for the bar which is a Row Grand Total.

In the below image, 'All Business' is the 'Row Grand Totals' to which I need Grand Totals on top of the bar.

enter image description here

Is there a way to achieve this requirement?

Jul 25, 2018 in Tableau by Atul
• 10,240 points
621 views

1 answer to this question.

+1 vote

Hi Grim,

As you have used reference line method.

  • Make sure first that your Label is value and value is (Sum of Row grand) and line in none.

If you have tried doing this already then 

  • Create a window_sum or LoD calc to calculate the totals. Drag this new calculated field to the Detail shelf. Then add it as a reference line.

Your alternative is to create a dual axis chart.Let me know if you need help in the same.

answered Sep 24, 2018 by Machdata
• 340 points
Hey Machdata,

Thanks for responding. Can you provide me with the LOD calculation within the calculated field?

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 8, 2018 in Tableau by Atul
• 5,530 points
322 views
+1 vote
1 answer

How to calculate the number of hours worked in Tableau?

Try using this LOD expression {fixed user : ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,530 points
95 views
0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
721 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12 in Tableau by Cherukuri
• 32,260 points
963 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,376 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
117 views
+2 votes
1 answer
0 votes
2 answers

How can I display filtered value and grand total in the same sheet?

You can create a fixed calculated field ...READ MORE

answered Sep 15, 2018 in Tableau by Machdata
• 340 points
104 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
70 views