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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Custom Date Formats in Excel Custom date formats in Excel allow you to display only certain parts of the date.Say you had a date of 18/02/1979, which coincides to be my birthday 🙂You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the...
Different Ways to Filter an Excel Slicer Excel Slicers are the best thing since sliced bread!They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that shows you what items have been filtered or selected in a Pivot Table.There are several ways that you can filter an Exce...
How to Use Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows lite...
Excel’s Fill Handle Tips This post was inspired by Mr.Excel's new book MrExcel XL: 40 Greatest Excel Tips of All Time and in particular the 3rd tip that I read called The Fill Handle Does Know 1,2,3...Excel knows to fill down/right when you are working with dates, days, months, years and even quarter...