Is there a way to add a Year-to-date column to a pivot table that list sales for specific customers in a specific months? The main filter is for Month-Year, but I need to add a Year-to-date column that will recalculate the total sales: if I filter for February sales, the YTD column should show the sum of sales for Jan and Feb, if I filter for November, the YTD column should display the sum of 11 months, Jan to Nov. Will Power Pivot/DAX expressions t be more helpful? The time range spans across multiple years.The result should look like this:

Click image for larger version. 

Name:	Capture_Pivot with YTD Column.PNG 
Views:	17 
Size:	5.8 KB 
ID:	9069

Thank you