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:
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