KNOWLEDGE BASE

Display Cumulative Sales by Year as a Bar Graph


Published: 16 Sep 2022
Last Modified Date: 16 Sep 2022

Question

How to display the cumulative sales by year as a bar graph.

User-added image

Environment

  • Tableau Desktop

Answer

1. Connect to the Sample-Superstore data source.
2. Drag Order Date to Columns and drill down by MONTH then remove QUARTER(Order Date) from Columns.
User-added image
3. Drag Sales to Rows.
4. Right-click on Sales on Rows and select Add Table Calculation.  Set the following:
User-added image
5. On the Marks card, change the graph type to Bar.
User-added image
6.  Press CTRL and drag YEAR(Order Date) on Columns to Color.
User-added image
Did this article resolve the issue?