Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Apr 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting Subtotaled List (2003)

    I have a list of timekeeper data by person by date by time entry. I want to combine all entries by day and then sort in descending order to see who, if anyone, has worked more than 12 hours in a day. I know how to combine, subtotal, etc.; however, I cannot sort once subtotaled. Is this possible? I have looked at some threads related to this but can really understand them.

    Can someone help?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting Subtotaled List (2003)

    Have you tried a pivot table?

    Steve

  3. #3
    New Lounger
    Join Date
    Apr 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Subtotaled List (2003)

    Can I sort on pivot table totals?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting Subtotaled List (2003)

    You can set the options to sort the pivot table in the formatting. You can also add a (auto)filter to the pivot to only display the items of a certain size.

    Steve

  5. #5
    New Lounger
    Join Date
    Apr 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Subtotaled List (2003)

    I right click and get the Options but see no way of doing this - sorting?

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting Subtotaled List (2003)

    Right-click the pivot table
    Field...
    [advanced...]
    Under Autosort options:
    Descending (or ascending)
    From the "using field" list chose the field to sort by.

    Steve

  7. #7
    New Lounger
    Join Date
    Apr 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Subtotaled List (2003)

    I right click on the table and get format options and data options but nothing like what you stated below. How do I get to the field, advanced, etc?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting Subtotaled List (2003)

    Double click a row or column field. You'll get the Advanced button then. See Microsoft Office Assistance: PivotTable reports for Sales 2: Compare sales of your products for some screenshots illustrating the dialogs.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting Subtotaled List (2003)

    It must be changed from XL97...

    I hope Hans' links helps you.

    Steve

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting Subtotaled List (2003)

    Yes, the Pivot tables context menu has changed considerably.

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting Subtotaled List (2003)

    I guess I will have to limit how much I can describe how to do things with a pivot table in other versions until I get a new version later this year...

    Steve

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting Subtotaled List (2003)

    The basic ideas are still the same, of course, as are most features, but some of the menus and dialogs look different.

Posting Permissions

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