Pivot table


M

MillyD

When i generate a pivot table the months order changes , Example below does
anyone know how to amend this

Month Total
Apr-08 0
Aug-07 0
Aug-08 0
Dec-07 0
Feb-08 0
Jan-08 1
Jul-08 0
Jun-08 0
Mar-08 0
May-08 0
Nov-07 0
Oct-07 0
Sep-07 0
 
Ad

Advertisements

A

Andrea Jones

It looks like your 'dates' are formatted as text. Try formatting the dates
in the original data list as mmm-yy (you'll probably have to press F2
followed by Enter on each date cell to make them convert properly from text
format).

Andrea Jones
www.stratatraining.co.uk
 
M

MillyD

just tried that ,,,,, and its still generate the same list

Never mind

Cheers anyway
 
Ad

Advertisements

R

Roger Govier

Hi Milly

You are doing an ascending sort on Month.
You need to Create a Custom list of dates for it to use
Tools>Options>Custom Lists>create a list
Aug 07
Sep 07
Oct 07
..
..
Jul 09

Go back to your PT>Double click on Month field>Advanced>Sort>OK>OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top