Pivot tables have a built-in feature to calculate running totals.
Fields
The source data contains three fields:Date,Sales, andColor.
Only two fields are used to create the pivot table:DateandSales.
Then add the Month field to the pivot table directly.
Steps to make this pivot table
