Results 1 to 6 of 6

Manually Sorting Pivot Table Row Labels

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2009
    Location
    Fairfax, VA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Red face Manually Sorting Pivot Table Row Labels

    Hi all!

    I am working with a PivotTable (and I'm new to them, so be gentle!) and I need to sort the table by row label manually. I have highlighted the following excerpt from the applicable Excel Help file.

    Sort data in labels
    ...
    Optionally, to customize the sort operation, on the Options tab, in the Sort group, click Sort.
    In the Sort <Field name> dialog box, select the type of sort that you want by doing one of the following:

    To return items to their original order, click Data source order. This option is only available for OLAP source data.
    To drag and arrange items the way that you want, click Manual.
    To select a field to sort by in ascending sort order, select Ascending (A to Z) by, and then select the field from the drop-down list.
    To select a field to sort by in descending sort order, select Descending (A to Z) by, and then select the field from the drop-down list.
    Tip Read the Summary section at the bottom of the dialog box to verify your choices.

    My problem is this: after following the above steps, then clicking Manual, then ok, I cannot drag and arrange the row labels in the PivotTable. I'm sure there is a simple solution to this problem, but if someone could walk me through it, I would greatly appreciate it!
    Last edited by brandonkmoon; 09-18-2009 at 02:29 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1