UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Order by Pivot Table    
 
   
cjthunderbay
post Feb 19 2004, 01:37 PM
Post #1

UtterAccess Member
Posts: 36
I have a field called 'Day' that has data for Days of the Week.
I put the Day field in the 'Column' section of the layout for the Pivot Table.

The order is alphabetical meaning Friday comes first, followed by Monday and then Saturday and so on.


How in a Pivot Table can I correct the order manually, so the days of the week would be in the proper order?
That is, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

Thanks,
cj
Go to the top of the page
 
+
vangie
post Feb 19 2004, 02:55 PM
Post #2

UA Editor + Utter Access Ruler
Posts: 1,844
From: California, USA
Hi. To do it manually you can go to the cell (Friday for example) and type the day (Monday for example) over it. This will change the order. Type the day you want to be on the first column, second column, and so on.


Good luck.
Go to the top of the page
 
+
KingMartin
post Feb 20 2004, 04:37 AM
Post #3

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
Hi,
drag 'n drop of the fields also works.
Martin
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 06:37 AM