excel 2007

I've a pivot table with lots of events and then the dates they occurred on horiz axis. All I want is to group by month & year (like I've always done in old Excel) but I'm too stupid to work out how

🙁

Pleaseandthankyou

forget that – I'm a genius again !

(was clicking on the axis, rather than table, which doesn't work in 2007 seemingly)

if you right click on the pivot table (cell A3 if you've inserted into a new sheet), select pivot table options, select display & check the "classic pivot table layout", you might find it a little easier.

"classic pivot table layout"

cheers (do they call it the luddite button ?)

It's the one I use 🙂