Pivot table showing April as Q1

%3CLINGO-SUB%20id%3D%22lingo-sub-3321381%22%20slang%3D%22en-US%22%3EPivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321381%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20an%20Excel%20file%20with%20a%20number%20of%20different%20pivot%20tables%2C%20all%20split%20into%20Year%2FQuarter%2FMonth.%3C%2FP%3E%3CP%3EOne%20of%20those%20is%20grouping%20April%20in%20with%20Q1%2C%20instead%20of%20Q2%20where%20it%20should%20be.%3C%2FP%3E%3CP%3EI%20can't%20see%20how%20to%20change%20that%2C%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Waltzingmatilda_0-1651739575540.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369399i43EC60350EC1A89F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Waltzingmatilda_0-1651739575540.png%22%20alt%3D%22Waltzingmatilda_0-1651739575540.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3321381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3321533%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381690%22%20target%3D%22_blank%22%3E%40Waltzingmatilda%3C%2FA%3E%26nbsp%3BWould%20need%20to%20have%20a%20closer%20look%20at%20the%20underlying%20data%2C%20as%20it%20seems%20that%20the%20months%20are%20shifted%20by%20one%20month.%20Where%20does%20January%20show%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3321779%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3CBR%20%2F%3EThanks%20for%20taking%20a%20look.%20There%20isn't%20any%20data%20in%20January%2C%20but%20if%20I%20put%20a%20test%20row%20in%20with%20Jan%202022%2C%20it%20also%20includes%20Jan%20in%20Q1%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Waltzingmatilda_0-1651743353162.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369419i1DB84702981353D5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Waltzingmatilda_0-1651743353162.png%22%20alt%3D%22Waltzingmatilda_0-1651743353162.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3321991%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381690%22%20target%3D%22_blank%22%3E%40Waltzingmatilda%3C%2FA%3E%26nbsp%3BStrange.%20As%20said%2C%20without%20looking%20at%20the%20data%20it's%20difficult%20to%20diagnose%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3330135%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3330135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BIs%20there%20any%20way%20to%20share%20that%20with%20you%3F%20It%20has%20sensitive%20data%20in%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3330279%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20showing%20April%20as%20Q1%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3330279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381690%22%20target%3D%22_blank%22%3E%40Waltzingmatilda%3C%2FA%3E%26nbsp%3BIf%20you%20could%20clear%20out%20the%20sensitive%20data%2C%20you%20could%20upload%20it%20to%20your%20post%20or%2C%20in%20case%20you%20don't%20have%20that%20option%20share%20it%20via%20OneDrive%2C%20Dropbox%20or%20something%20similar.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I have an Excel file with a number of different pivot tables, all split into Year/Quarter/Month.

One of those is grouping April in with Q1, instead of Q2 where it should be.

I can't see how to change that, any suggestions?

Waltzingmatilda_0-1651739575540.png

 

 

5 Replies

@Waltzingmatilda Would need to have a closer look at the underlying data, as it seems that the months are shifted by one month. Where does January show up?

@Riny_van_Eekelen 

Hi,
Thanks for taking a look. There isn't any data in January, but if I put a test row in with Jan 2022, it also includes Jan in Q1:

Waltzingmatilda_0-1651743353162.png

 

@Waltzingmatilda Strange. As said, without looking at the data it's difficult to diagnose the problem.

 

@Riny_van_Eekelen Is there any way to share that with you? It has sensitive data in it

@Waltzingmatilda If you could clear out the sensitive data, you could upload it to your post or, in case you don't have that option share it via OneDrive, Dropbox or something similar.