Show Running Total in Excel Pivot Table

With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through another field, such as products, or customers.

In the screen shot below, the Quantity field shows a running total across the Months column. In March, the Year To Date total for Corner Cabin is 2595.

Show Running Total in Excel Pivot Table http://www.pivot-table.com/

Video: Show Running Totals

Watch this video to see the steps for creating a pivot table, changing the values to show a running total, and removing the Grand Total for Rows, which is no longer needed.

Or watch on YouTube: Show Running Total in Excel Pivot Table

Download the Sample File

To follow along with the video tutorial, you can download the sample file from my Contextures website, on the Pivot Table Running Totals page.

The zipped file is in xlsx format, and does not contain macros.

_______________

This entry was posted in Group and Total. Bookmark the permalink.

One Response to Show Running Total in Excel Pivot Table

  1. Pingback: Excel Roundup 20141027 « Contextures Blog

Leave a Reply

Your email address will not be published. Required fields are marked *