Forum Discussion
Solved
Incorrect dates with the last week filter in a pivot table
I have a big table with transactions from 01-Jan-2019 until today (more then 100 000 rows so all dates have transactions). I want to make pivot tables where I filter on this and last week. But I ...
- Are you sure your data includes the seven days of last week?
I don't think you can change what Excel defines as last week. See this discussion: https://stackoverflow.com/questions/25035822/how-to-set-the-week-start-day-in-a-pivot-table
Are you sure your data includes the seven days of last week?
I don't think you can change what Excel defines as last week. See this discussion: https://stackoverflow.com/questions/25035822/how-to-set-the-week-start-day-in-a-pivot-table
I don't think you can change what Excel defines as last week. See this discussion: https://stackoverflow.com/questions/25035822/how-to-set-the-week-start-day-in-a-pivot-table