Pivot Table

New Contributor

Hi there,


I have an interesting challenge, I have a spreadsheet with 53,000(ish) rows with 25 columns of data.  I have a date column; with data entered each week and when I create a pivot table the date in the pivot table defaults to year, quarter or date (that shows only the month), and I just want to see each week.  Is there a setting that I need to toggle to see each week in the pivot table?   Thank you.

3 Replies
Add a column to your data, and use the WEEKNUM function to convert the full date from your date column into a week number (it does it for whatever week it is out of the 52 weeks in the year). Your pivot table would use that WEEKNUM column to display the results you're looking for.
Clearing the pivot grouping then group by Days - 7 day interval.
Thank you Patrick. Cheers.
Related Conversations
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies