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 can also activate this by going in to the Value Field Setting section, which is the method that I show below.

DOWNLOAD WORKBOOK

Running Total In_YTD

Helpful Resource:

728x90

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

Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below. DOWNLOAD WORKBO...
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...
Errors When Grouping By Dates With Excel Pivot Tab... In our Group By Date post, we grouped our sales numbers by weeks. However there are times when we try to group by Dates and we get an error message!  That is frustrating! Instead of checking the dates one by one to find out where the error occurred, I will show you a cool w...
Distribute and Align Shapes in Excel Imagine you have a lot of shapes in your Excel file and the shapes are all over the place! You want to organize the shapes but it seems a pain to move them one by one! What would you do? Thankfully, Excel allows you to distribute and align shapes! This is our initial ...