MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
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
Posted : 16/09/2010 8:01 am
Topic starter
forget that - I'm a genius again !
(was clicking on the axis, rather than table, which doesn't work in 2007 seemingly)
Posted : 16/09/2010 8:03 am
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.
Posted : 16/09/2010 8:12 am
Topic starter
"classic pivot table layout"
cheers (do they call it the luddite button ?)
Posted : 16/09/2010 8:13 am
It's the one I use 🙂
Posted : 16/09/2010 11:07 am