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

Extract Numbers Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is extracting the numbers from your text au...
Insert a Pivot Table Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks.  It is the most powerful tool within Excel due to its speed and output and I will show you just how easy it is to create one. If you are using a table or data set to analyze your informat...
Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data. You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Fix Incorrect Formatting Using Flash Fill In Excel   Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically. Ever had the scenario where your data is formatted differently? Example: First names starting wit...