Pivot table help

%3CLINGO-SUB%20id%3D%22lingo-sub-2095274%22%20slang%3D%22en-US%22%3EPivot%20table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095274%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20source%20data%20is%20showing%20in%20daily%20buckets%20but%20when%20I%20create%20a%20pivot%20table%20it%20changes%20to%20monthly%2C%20ultimitly%20I%20would%20like%20to%20see%20it%20in%20weekly%20buckets%2C%20can%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2095274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095390%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942171%22%20target%3D%22_blank%22%3E%40MJJ987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERight%20click%20on%20it%2C%20Grouping%2C%20here%20select%20only%20Days%20and%20Number%20of%20days%20%3D%207%2C%20adjust%20Start%20and%20End%20if%20necessary%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249259iB1CDC85D9C92F743%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EResult%20will%20be%20like%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorSergei%20Baklan_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2095396%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2095396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942171%22%20target%3D%22_blank%22%3E%40MJJ987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESecond%20screenshot%20disappeared%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20186px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249264iC7F12CE1D1F263BD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

My source data is showing in daily buckets but when I create a pivot table it changes to monthly, ultimitly I would like to see it in weekly buckets, can anyone help?

3 Replies

@MJJ987 

Right click on it, Grouping, here select only Days and Number of days = 7, adjust Start and End if necessary

image.png

Result will be like

 

@MJJ987 

Second screenshot disappeared:

image.png

@MJJ987 

Alternatively you may add week # column directly to the source; or creating Pivot Table add data to data model and add in it; pivot on week #

image.png

You may add as well Year, Month, Date (whatever)  to hierarchy if necessary.