Home

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
BoxerBoy
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies