Thu 4 Jan 2007, 15:27Delegate Clodagh said...
Clodagh has attended:
Excel Advanced course
Pivot Tabe Formatting
Hi
I did an excel course with yourselves last year. I have a query relating to pivot tables that I cannot find a way around. I tried to log into my delegate account but I cannot remember the password so I hope it is ok to send it to this address.
What I
Fri 5 Jan 2007, 15:33Trainer Jacob said...
RE: Pivot Tabe Formatting
Hi clodagh
One work around is to change the foramt of your dates from Month, Year to month/day/year, i.e; 01/05/2007
By doing this when you list in ascending order it will do so by month.
Hope this helps.
