+ Reply to Thread
Results 1 to 4 of 4

Sort Pivot Table Based on Partial String

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Sort Pivot Table Based on Partial String

    I've got a group of data within a pivot table that I want to be sorted based on only part of the string.

    For example,

    Standard Kitchen
    Standard Master Bath
    Standard Hall Bath
    Optional Kitchen
    Optional Basement Bath

    First they would be sorted by whether they begin with Standard or Optional. Then within those groups, they would be sorted whether they contain Kitchen anywhere in the string. So that the order would be Standard Kitchens, Standard Anything Else, Optional Kitchens, Optional Anything Else.
    Last edited by yawnzzzz; 10-08-2008 at 02:41 PM.

  2. #2
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387
    The data that needs to be sorted would be in the Row Fields section.

  3. #3
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387
    Still looking for some help on sorting Pivot Tables.

  4. #4
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387
    The simplest way I found to do this was to just create an Order column in my data. This was simplest, since I was generating the data. Then I put it in as the main column, and sorted by it. After that, I hide that column, so it appeared like it wasn't there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. To formulate a table based off a single row of Pivot data
    By money n da sank in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2008, 11:28 AM
  2. How to sort Pivot table columns?
    By ramki in forum Excel General
    Replies: 1
    Last Post: 07-16-2008, 02:29 AM
  3. pivot table to ingore formulas in data table
    By nicko54 in forum Excel General
    Replies: 0
    Last Post: 07-10-2008, 10:30 AM
  4. Changing Pivot Table Headings
    By proline241 in forum Excel General
    Replies: 0
    Last Post: 12-12-2007, 04:00 PM
  5. Extending Data Range of a Pivot Table
    By Rabi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2007, 06:14 AM

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