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
|