Pivot Table Sort Issue

Hi
Using Excel 2003 and the field Month (Jan....Dec), moved into the Row area. 
Been working fine (special month sort order) for months. Now the months do 
now sort "correctly" (Jan....Dec), but sorts Jan...Dec with May and Jun in 
the last 2 positions. All other 10 months sort correctly.
?
thanks,
Gene:)
0
Utf
12/15/2009 8:13:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
745 Views

Similar Articles

[PageSpeed] 7

Maybe its a data issue -- text dates/real dates ? 
Check the recent data. Ensure all are real dates.
-- 
Max
Singapore
--- 
"Gene Moirao" wrote:
> Using Excel 2003 and the field Month (Jan....Dec), moved into the Row area. 
> Been working fine (special month sort order) for months. Now the months do 
> now sort "correctly" (Jan....Dec), but sorts Jan...Dec with May and Jun in 
> the last 2 positions. All other 10 months sort correctly.
> ?
> thanks,
> Gene:)
0
Utf
12/15/2009 9:56:02 PM
Reply:

Similar Artilces:

Printing Issues when distributing a form to multiple users
I am distributing a spreadsheet to multiple users. The spreadsheet is being used as a form for data entry. The problem i am having is that when it is being printed, the users are getting varying page layouts where the page breaks have changed, due the changes to the length of the document growing from the free text they are entering. The page breaks that excel chooses don't seem to be spaced well, leading to one or two of the pages being very short (i.e., leaving a lot of free white space), whereas the other pages are taking up the entire page. Is there a particular page layout selection...

Pivot Table
I've this problem, when I drag the fields into the "Data" area, it will show as "Count of Q1 Results". But what I actually want is "Sum of Q1 Results". I would have to manually go to field setting and reconfigure from count to sum. It happens for all the fields I drag into the "Data" area. Is there any way around this? Thanks. If there are blank cells, or cells with text, in the column, Excel will default to the Count function when the field is added to the data area. If the column contains only numbers, it should default to Sum. Derrick wr...

How to paste a cells row from Excel to a PowerPoint 2003 Table row?
Hello! How to paste a row of cells from Excel to a PowerPoint 2003 Table row? PowerPoint 2003 pastes all the row cells values in every cell in the row in the PowerPoint table if I select the row in the PP table before the pasting. PP pastes the row as an overlapping column if I place cursor in the first cell of the target row before pasting. Best regards, Dima +7 9163876746 +7 9035093892 ...

Issue when using Outlook 2003 on Exchange 5.5 SP4
Hi! I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can anyone guide me on how to handle this? M P What issues have you seen? -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "M P" <mark@textguru.ph> wrote in message news:eoqSaBjTGHA.5884@TK2MSFTNGP14.phx.gbl... > Hi! > > I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can > anyone guide me on how to handle this? > > M P > It was pretty easy for me to find this in the Microsoft Knowledge Base: http://support.microsoft...

Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed working fine until when I try to create the Pivot Table Report (Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the pre-defined 'Definition ID' and click on the Excel icon, a message popped up saying " The WHTemplate.XLT file was not found." Anybody have any idea what that is, and how to resolve it?? Thanks. 1.) There are two pieces of software. Did you install both the server piece, and the client piece? 2.) Is Excel installed on the machine, on which you'r...

I would like to export the data from a drop-down list to a table
I have a form with several drop-down lists, I need to have the information in these lists in another document/spread sheet. Is there an easy way to copy the data in these lists to another location? The long way would be to re-type all of it. ...

changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is completely missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, the table is empty and its .err file is also blank. If the .err files do not show...

Importing a table from Access query
What is the quickest and easiest way to do the above? Thanks in advance. Hi The way I usually do this is run the select query, click on the top-right box (which selects all records) and use Ctrl+C to copy and Ctrl+V to paste into my workbook. An alternative is to right-click on the query in the Database Window and left-click on Export. In the Save As dialog box, select ..xls type. -- Andy. "Trish" <Trish@discussions.microsoft.com> wrote in message news:6BF3DE22-6590-4CAD-9EE1-FC978A3BB63B@microsoft.com... > What is the quickest and easiest way to do the above? >...

Write conflict error with ODBC link table
Hi, I have migrate my back end access tables to SQL Server. While editing data (ODBC link) from form, I receive Wirte conflict error 'The record has been changed by other user... Copying the change to the clipboard...'. The error allow me either copy the info to clipboard or drop change. In this case, how can I save my work to the table here? SF � "SF" <xyz@online.com.kh> ������ ��� ������ news:#F7F7OtcIHA.5160@TK2MSFTNGP05.phx.gbl... > Hi, > > I have migrate my back end access tables to SQL Server. While editing data > (ODBC link) from form, I...

How do I sort a proctected worksheet
Unprotect it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Audrey" <Audrey@discussions.microsoft.com> wrote in message news:1E1AC0AE-67F0-46B1-A741-B32D4DF69D43@microsoft.com... > That is a given, but I have columns that I don't want sorted. I have locked those columns in hopes they would not sort and the others would. Any suggestions? Thanks for the help. "Chip Pearson" wrote: > Unprotect it. > > > -- > Cordially, > Chip Pearson > Microsoft MVP - Excel > Pearson...

Need a formula that tags one table based 2 columns in each table
I have two tables on one worksheet, Table A and Table B. Each table contains two column with X and Y coordinates, all values are numerical. The coordinate system is irrelevant. I need to "tag" all XY coordinates in Table B that have a matching XY coordinate in Table A. If Table A coordinates are in columns A and B, and Table B coordinates are in columns C and D, then I want to place the text "hit" in column E next to each coordinate pair from columns C and D that match a coordinate pair in columns A and B. The ranges for the respective tables have been named ACOORD and...

OL2000/MAPISP32 issue
This one has me baffled. I think it might have to do with the AVG antivirus software I recently installed, with which I am generally perfectly happy. But it could be something else. Outlook 2000 is set up to automatically check mail on my ISP's POP3 server every x minutes. It is also set up to pass outgoing message to the SMTP server as soon as they are completed. This works fine most of the time. However, occasionally (a couple of times a week), I will notice I haven't gotten any mail at all for a few hours, so I manually check mail and get a popup asking me to re-enter the name of ...

"How do I get rid of old records in an Pivot Table?
The spreadsheet gets copied each month to a new file and the data cleared out, BUT the selecetion in the Pivot Table still holds the data from Previous spreadsheets Debra Dalgleish has some techniques at: http://www.contextures.com/xlPivot04.html AyPee wrote: > > The spreadsheet gets copied each month to a new file and the data cleared > out, BUT the selecetion in the Pivot Table still holds the data from Previous > spreadsheets -- Dave Peterson The web-link was very helpful, thank you. I was about to reprogram and build my pivot tables to get rid of the obsolete item...

Line chart categoray axis labels issue
Hi, I have two problems (bugs perhaps) that I need o find a way to work around in Excel 2007. They both concern the category (x) axis (text) labels in line charts. I normally shy away from line charts entirely but, in the given instance I need to use them. First question: when you first create the line chart, and when you set the labels for the category axis, Excel automatically rotates the labels to get them to fit as well as possible. However, if you go in to the Format Axis> Alignment>Custom Angle box and enter a value, I can find no way of reenabling Excels automatic selectio...

Pivot table help I think !
Hi All, I have a report I need to create which goes as follows. I have a data list of around 56k records. The rows contain this; category 1, category 2, category 3, call id and Date I've created a pivot table with Cat1, cat2, cat 3 on the row area, Count of Call ID in the data area and date in the column area (this is grouped by Month). I'm looking at the months of Mar, Apr and May. I want to sort it, in descending order, by the difference of 'Count of Call ID' there is between Mar and May. If I cannot perform the calculation in the pivot table, is there a way of ungroupi...

Adding multiple tables in one report
I am trying to customize the default report Daily Detailed Sales with Tax. What i need to do is add the Tender Type (Credit card / cash / check) as another column in the report. So far i have found out: i need to add a column i need to import the TenderEntry table for the data I need to find out: How to import another table I have tried to import the table using sql UNION function, but that wont work for me either. any help would be greatly appriciated. Thank You Hi ED, The things make sense to me regarding the adding tables and fields which you can do and customized the .grp file. ...

Force data type from Text to Memo in a simple Make Table Query
I'm concatenating fields of various data types that upon completion sometimes reaches around 500 characters. Not huge, but larger than the Text limitation to which is what Access 2007 of course converts this. How can I force the data type to be Memo while I'm in the query so the resulting table displays all the data without any truncation. -- TIA Eric S UPRR I don't believe you can. I think you'll have to create the table first, and then append to it. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "E...

Post Install issue!
I have installed CRM to the same Windows 2003 server as AD and SQL. Just for testing - I know what your thinking. Any how after the install when I try to add users I always get "Insufficient rights to add user contact admin" I have gone through the Implementation guide step by step. I have installed this to another Windows 2003 server with the same results. I have looked through about 40 pages of posts on this site and no one seems to have had this issue. Any thoughts? You have not assigned your self a license >-----Original Message----- >I have installed CRM to ...

CRM V1.2 and SBS 2003 Not Working installation issues
Greetings and Happy New Year My Question is why doesn't CRM behave correctly? Environemnt is SBS2003 Premium Exchange Configred and running correctly. ISA running using 2 Nics. Domain with active directory running ok. SQL 2000 with service packs 3a applied. IIS running ok default websites all accessable. Firstly i followed the IG for SBS2003(Fresh Install with all updates) all prerequisites were ticked off prior to installation. Install procedure was followed to the letter. Results :( http://localhost causes IE to spit up You do not have permissions to view this Web Site. What ...

Pivot Table toolbar
Every time I edit a pivot table (Excel 2000)the toolbar launches itself and I have to then re-anchor it manually - this is very irritating! Is there any way to stop this happening? "GeoffS" <crammond-smith@tiscali.co.uk> wrote in message news:39d201c355a8$a7f788b0$a001280a@phx.gbl... > Every time I edit a pivot table (Excel 2000)the toolbar > launches itself and I have to then re-anchor it manually - > this is very irritating! > > Is there any way to stop this happening? I use Excel97 but it may be the same. You can have the toolbar on all the time, positio...

Issue with one account's password...
I've been beating my head against the wall on this one for awhile now... I have one user who's password will not work. I've tried resetting it numerous times, and it will still not allow her or myself to log in. What could I be missing here? Keep in mind that I'm pretty new to this Exchange Server stuff in any replies you may have. Thanks so much for any help you can throw my way! By the way, the password is very simple, so it's not an issue of mis-typing. Also, I've given it plenty of time to update the AD listing, so that shouldn't be an issue, right?...

Pivot tabels -- Incorrect sorting of specific value in pivot table
A message was posted yesterday that has not shown up so this is a second attmpt. I have a pivot table that consistently places a value at the top of the sorted llist (bottom if decending) even though that value should be in the middle of the list. A sample of the values are ALC, SNO, CET, ESU, TEL, STR, JUN, NKA, NTL, blank. The JUN value is always at the top. Any value placed in the field that begins with J shows at the top. If the value is changed to any other letter, it sorts correctly. The data has been reentered at the source, the query checked, and the downloaded data chec...

table of contents
I am trying to build a table of contents from the headings in my employee handbook. I have heard that this is possible, and if I change the content of the handbook, the page numbers, etc. will automatically update. What is the process to accomplish this? I would appreciate any insight given. Thanks! ...

pivot table in reverse
I' ve got a spreadsheet with events as row headings, people's names as column headings and dates in the cells. E.g. Person 1 Person 2 Birthday 01/07/61 05/10/67 Anniversary 10/08/90 10/11/92 (Actually the list is much longer....) Now I want to make a new list list converting the above data to [dates (in column 1; event in column 2; person in column 3]. Sort of pivot tables in reverse......!! How to? Wim Hi, I may not be reading your post correctly but I think searching fo "Transpose" in the He...

Workflow Email Template issue
I have workflows that send Email templates to user and customers within CRM. I have been doing some modifications in the workflow rules and now anytime a workflow sends an Email template it hangs up. I check the Workflow monitor and the workflows are paused. When I open the workflow it has a Yellow bar over the Email template process. I recently restarted the server. Is there a service that needs started manually because the server tells me a service did not start? Thanks for any help that can be given. you can check the server event logs to see if you have any errors there -- John O&...