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:

DOWNLOAD EXCEL WORKBOOK

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

HELPFUL RESOURCE:
PIVOT BANNER

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily... See how to Show The Difference From Previous Months With Excel Pivot Tables here Now that we have the Pivot Table report above, we can show the variances per month using an up/...
Excel Table: Styles There are lots of different Table Styles that you can choose from to spice up your Excel Table.  You can also customize your own style if you don't like any of the default Excel styles. To access the Table Styles, you simply need to click inside your Table and then the Table T...
Rank Smallest to Largest With Excel Pivot Tables   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the RANK SMALLEST TO LARGEST calculation. This option will immediately calculate the rankings (1 being the smallest value) for your values, allowin...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac. They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...