View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RMF
 
Posts: n/a
Default Using Order in Excel Pivot Tables

I am having a similar issue. changing the order via dragging works, but
perhaps there is a easier way for me to order my pivot. I have a data sheet
with dates that are entered in the following format:

dd/hhmm, e.g. 12/0700

Is there a way of sorting this automatically in a pivot? If I would create a
list I would have to enter from 01/0001 until 31/2359 by entering 01/0001,
01/0002, 01/0003 and so on which is of course time consuming.

Is there a solution for this one?

Thnks!

"Matt Cromer" wrote:

Is there an easier way to use the Order function in Pivot Tables. Order,
Move Up/Move Down/Beginning...seems very awkward. The fields that I have
cannot be sorted ascending the traditional way, so I have to order them
manually. Are there any hot keys, or other ways to order??

Thanks!

Matt