medium10 pts · first answer countsexcelpivot-tablesdates

January shows two years together

Sales cover Jan 2025 to Dec 2026. After grouping the pivot's date field by Months only, January shows a total twice the normal size. Why?

A.The pivot counts every January date twice by mistakeB.Grouping by month always doubles the first monthC.January 2025 and January 2026 were merged into one groupD.The pivot needs refreshing after any grouping

Discussion 0

Join free to post in the discussion.

January shows two years together

Discussion 0

Related questions