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!
Bookmarks