Excel pivot table problem - can't Group dates | AccountingWEB

Excel pivot table problem - can't Group dates

i am currently using my own data to try out the the tutorial provided by excelzone in accountingweb.co.uk - 'Five minute's pivot table tip'.

i am trying to sort out the invoice listing into detailed ageing format. hence, for row - name, invoice number, column - date(dd/mmmm/yyyy), date - amount in GDP & USD.

so i try to change the date to month by following the tips given in excelzone. but message pop up and said 'cannot group that selection'.

i dont know where have i gone wrong. can anyone here please pinpoint out to me so that i can rectify it? thanks a lot
Ken Wen

There are 4 comments. Login or register to view them.

Thanks David

mingali |

see Tip no 18

David Carter |

thank David

mingali |

you have to sort out the Data range in Step 2

David Carter |