Hi All -- I've been searching and I can't find a solution.

I have a pivot table that I need to show values for the most current 10 weeks which means it drops a week and adds a new week each week the report is run.

Do I need to program this? Or is there a setting that I'm just missing that will allow the column headers to match what is in the data.

Note: The data will also only contain the most current 10 weekending dates. So, I create the pivot table with:

Column headers:

8/15, 8/22, 8/29....10/10

Data contains the same in Column 1 of the table.

The next week's actual table data will contain the dates 8/22, 8/29, 9/5...10/17

But when I refresh the pivot table, the actual data changes but the column headers still reflect the 8/15, 8/22, 8/29....10/10 with now an additional column of 10/17 even though the underlying data table doesn't contain any values of 8/15.

How can I rotate the columns or does anyone else have a suggestion of how to display this?

My datatable looks like this:

WeekEnding Dates (Col 1), RowType (Col 2), Days (Col 3), Records (Col 4)

Pivot table:

Columns = Col 1
Rows = Col 2 values

Thanks!