A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis.

A Running Total In takes one period’s values, then adds a second period, then a third period…and so on, to give the accumulated values up to a certain period.

This can be show in dollar form or in percentage form.

With an Excel Pivot Table we can easily include this calculation without the need to use any formulas.  Here is how:


STEP 1: Insert a Pivot Table by clicking in your data and going to Insert > Pivot Table and choose to insert it in a New or Existing Worksheet

insert a pivot table

create pivot table


STEP 2: You will need to put the Months Field in the ROW area, the Year Field in the COLUMN area and then put the Sales Field in the VALUES area two times!

pivottable fields


STEP 3: Right Click on a Totals cell and choose Remove Grand Total

remove grand totals


STEP 4: Right Click on a Sum of SALES2 value and select Show Values As > % Running Total In  > Base Field: Month

% running total in

Base Field


STEP 5: You can manually change the name of the Sum of SALES2 Field by clicking in the cell’s title within the Pivot Table:
manually change field name


STEP 6: We can insert a Pivot Chart by clicking in our Pivot Table and going to PivotTable Tools > Analyze/Options > Pivot Chart

pivot chart


STEP 7: From the Insert Chart dialogue box you need to choose the Combo chart and “check”the Secondary Axis box for the YTD% Series and press OK

insert combo chart


You now have your % Running Total In values on a Pivot Table and also shown graphically on a Pivot Chart:

pivot table ytd

pivot chart ytd

Year To Date Percentage


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format.  Then you can choose from the many different formats, like Number, Currency, Percentage or Custom.DOWNLOAD EXCEL WORKBOOK STEP 1: Right click in the Pi...
Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...
Consolidate in Excel with the CONSOLIDATE Tool The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range.You would use this feature when you have a single text column on the left and the column has many duplicate values.First you need to select a blank cell o...
Show Pivot Table Values As a Running Total In If you want to track your sales on a monthly basis and see their Year to Date totals, then you can easily do this with the Running Totals In calculation.You can activate this by Right Clicking on your Pivot Table values and choosing Show Values As and Running Total In.  You c...