Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-917655%22%20slang%3D%22en-US%22%3EPivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917655%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20interesting%20challenge%2C%20I%20have%20a%20spreadsheet%20with%2053%2C000(ish)%20rows%20with%2025%20columns%20of%20data.%26nbsp%3B%20I%20have%20a%20date%20column%3B%20with%20data%20entered%20each%20week%20and%20when%20I%20create%20a%20pivot%20table%20the%20date%20in%20the%20pivot%20table%20defaults%20to%20year%2C%20quarter%20or%20date%20(that%20shows%20only%20the%20month)%2C%20and%20I%20just%20want%20to%20see%20each%20week.%26nbsp%3B%20Is%20there%20a%20setting%20that%20I%20need%20to%20toggle%20to%20see%20each%20week%20in%20the%20pivot%20table%3F%26nbsp%3B%20%26nbsp%3BThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-917655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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
Highlighted
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.
Highlighted
Clearing the pivot grouping then group by Days - 7 day interval.
Highlighted
Thank you Patrick. Cheers.