excel - Group same date values in PivotTable -


I have some data that is a pivot table, which is basically a customer Donation (amount). The issue with me is that I can not group months of dates. I tried the group but it was not working PRICE LINE LABEL DATE TRANSCISE AMOUNT EUR_EQUIVAL MAX XYZ Jul-10 1 15.000,00 15.000,00 15.000,00 September -10 1 15.000,00 15.000, 00 15.000,00 October -10 1 15.000,00 15.000,00 15.000,00 October -10 1 5.000,00 5.000,00 5.000,00 November -10 1 1.250,00 1.250,00 1.250,00 Dec-10 1 15.000,00 15.000,00 15.000,00 People -11 1 7.000, 00 7.000,00 7.000,00

So from top I want to merge "October-10"

If the code recognizes date transaction field As a date data type, then right-clicking in the field on the Smoke and choosing the group and show extension option within the context menu Are there.

If this does not work, and you only know the month, try changing the data - e.g. September 1, 2010 for September -10 value etc.

Comments