View Full Version : YTD column

2019-04-26, 04:13 PM
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:


Thank you