YTD column

Ballet4Ever

New member
Joined
Apr 25, 2019
Messages
4
Reaction score
0
Points
1
Excel Version(s)
office 365
Hello,
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:

Capture_Pivot with YTD Column.PNG

Thank you
 
Back
Top