In this blog, I want to discuss how to create a Stacked bar chart with two measures and totals of the stack at the end. In my earlier blog, I showed how to display total on a stacked bar chart in Tableau. That stacked bar was created using only one measure and was relatively easy.

Creating Stacked Bar chart with two Measures

First we will create a stacked bar chart with two measures and then we will apply Totals to it. You can use Tableau Public or desktop for this exercise. 

1. Connect to Sample-Super store.xls data set. Use the Orders table.
2. From the data pane, place a dimension such as Order Date on the Rows. Place Measure Names on the Color.
3. Right-click on the Measure Names on the Color and select Filter. On the Filter screen, select the measures which you want to include in your stack chart. I will choose Profit and Quantity.

4. From the data pane/Measures, place Measure Values on the Columns. This will create your Stack bar chart. 

5. Place Measure Values on the Label card. This will show you the numbers on the bar.

Creating Totals on the Stacked bar chart with two measures

Now we would like to add totals at the end of the bar so that the numbers of Profit and Quantity can add up to Totals.

1. Create a calculated field. Navigate to menu Analysis and select Create Calculated Field. Name the calculated field as Total and use the following calculation:   

                                        Profit + Quantity 

2. Drop this Total calculated field next to Measure Values on Columns. This will show you two bar charts.

3. On Columns, right-click on Sum(Total) and select Dual Axis. Right-click on the axis and choose “Synchronize axis”.

4. Click on the Sum(Total) on the Columns again. Navigate to Marks and change the shape of Sum(Total) to circle.

This will give you a Stacked Bar chart with Totals at the end, depicted with a circle.