Forum Discussion
Pivot table showing April as Q1
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...
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?
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 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
