{"id":205,"date":"2014-02-02T18:04:31","date_gmt":"2014-02-02T10:04:31","guid":{"rendered":"http:\/\/excelchamp.net\/?p=205"},"modified":"2022-07-11T06:27:41","modified_gmt":"2022-07-10T22:27:41","slug":"how-to-get-running-totals-in-a-pivot-table","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/how-to-get-running-totals-in-a-pivot-table\/","title":{"rendered":"How To Get Running Totals In a Pivot Table"},"content":{"rendered":"

Pivot Tables are great in summarizing data from thousands of rows in just seconds. You can get Sum, Count, Average of numbers from any grouping in a Pivot table.<\/p>\n

But the one thing that you need at times is a running total in a column. For example, in January, you sold 100 cans, and in February you sold 120 cans. So the total cans you sold till Feb is 100+120=220. This is a running total up to the month of February.<\/strong><\/p>\n

If you want Excel to do this, you can write a formula in the data cells. But to get this thing done in a Pivot Table, you need to use a different way. And it is already pre-built in\u00a0 Excel Pivot Tables, starting from Microsoft Excel 1995.<\/p>\n

\"Raw<\/a>
Raw data for Pivot Table<\/figcaption><\/figure>\n

All you need to do is to click on the Data Field<\/strong> in the Pivot Table Field List<\/strong>, and a popup comes up.<\/p>\n

Choose the last option – Value Field Settings<\/strong>.<\/p>\n

Move to the Second Tab – Show Values As.<\/strong><\/p>\n

Then select “Running Total in<\/strong>” in the drop-down. Select a base field. It must be a text field, like Product, Category, Region etc.<\/p>\n

\"Show<\/a>
Show Values As – Running Total In<\/figcaption><\/figure>\n

Voila, you get a running total in the data field inside the pivot table. And all you did was to select the correct option. No formulas to write… no calculations to make or check. Isn’t it wonderful?<\/p>\n

\"Running<\/a>
Running Totals Calculated<\/figcaption><\/figure>\n

Using % Running Total In<\/strong><\/p>\n

Similarly, if you choose % Running Total In as the calculation, the running total numbers would be displayed as a percentage of the total. Giving you a much nicer perspective.<\/p>\n

\"Running<\/a>
Percentage of Running total<\/figcaption><\/figure>
\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Want to Improve Your Excel Skills?<\/strong><\/span><\/p>

Learn the Key Features of Excel Quickly & Easily, by <\/span>Joining the
Online Training<\/strong> on <\/u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p>

To Get Most out of Excel, Learn the\u00a0 Pivot Table techniques in our
Pivot Table Masterclass Training<\/a><\/u><\/b>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t
\nIf you’d like to learn more Excel Pivot Table Tricks<\/strong>, here are some additional articles:<\/p>\n