How to create a line graph with line for Total Sum of other lines in Tableau

In this silent video, you’ll learn how to create a line graph with a line that represents the sum total of the data points of all other lines.

- - - - - - - - - - - - - -

1. Drag Order Date to Columns
2. Right-click Order Date on Columns and select Month (continuous).
3. Drag Sales to Rows
4. Drag Sales to Rows again
5.Right-click on the second SUM(Sales) measure on Rows and select Dual Axis
6. Right-click the axis to the right of the view and select Synchronize Axis
7. Select SUM(Sales) (2) on the Marks card
8. Drag Category to Color

Related solutions:

- - - - - - - - - - - - - -