Forum Discussion
Using Excel to create count number report
There is no column named as MONTH.
There is a report where you can see month by month the result of the payments (quantity and summation)
When we put a date on a column we can manage it with some different date formulas such as Month(Date).
Have a look, I posted a file with the same data provided by you.
I am totally lost on how you used the date to produce "Month" column under the PivotTable Field List. I believe this goes to your statement that "When we put a date on a column we can manage it with some different date formulas such as Month(Date)".
Excel auto identifies that the field is a date type field and then group it in:
Years > Quarters > Months > Full date.
I'm not sure if Excel 2007 version does that, but take a look on thishttps://support.microsoft.com/en-us/office/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725Ps.: Dont forget to hit the like button and mark as solved if its solved.