+ Reply to Thread
Results 1 to 3 of 3

Pivot table alphabetic sort request

Hybrid View

Stu100 Pivot table alphabetic sort... 03-09-2010, 09:14 AM
JeanRage Re: Pivot table alphabetic... 03-09-2010, 09:32 AM
Stu100 Re: Pivot table alphabetic... 03-09-2010, 09:37 AM
  1. 03-09-2010, 09:14 AM #1
    Stu100 is offline
    Registered User
    Join Date
    07-25-2008
    Location
    Wales
    MS-Off Ver
    2007
    Posts
    64

    Pivot table alphabetic sort request

    Hi all,

    ..I have approx. 50,000 rows of data which I have sorted by customer, (approx 50 customers)
    .
    However, when I create a pivot table using the "Customer" field, the data table generated does not list the customers in alphabetical order???

    ..any reason why this would not be so?

    Many thanks,

    Stu
    Last edited by Stu100; 03-09-2010 at 09:36 AM.
    Reply With QuoteRegister To Reply
  2. 03-09-2010, 09:32 AM #2
    JeanRage is offline
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Pivot table alphabetic sort request

    Hi,

    Just double click on the field name, and pick the appropriate sorting option ...

    HTH
    Reply With QuoteRegister To Reply
  3. 03-09-2010, 09:37 AM #3
    Stu100 is offline
    Registered User
    Join Date
    07-25-2008
    Location
    Wales
    MS-Off Ver
    2007
    Posts
    64

    Re: Pivot table alphabetic sort request

    ..sorted many thanks........
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1