+ Reply to Thread
Results 1 to 4 of 4

Pivot Table formatting

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Pivot Table formatting

    After writing my question out I pretty much answered it, but I still have one question.

    One of the columns in my spreadsheet, "Rental Type," has three different items. In-town, one-way, and rotation (for different types of truck rentals). The row item is a truck transaction and that descriptor tells what type it is.

    I want to add two of the columns together, in-town and rotation, but because they're not their own separate columns in the spreadsheet, it doesn't look like I have that option. Is there a way to do this?

    Here's how the spreadsheet is designed:
    District | Company | Rental Type | Model | UD | PO
    .....1............10............IT...............DC.......1.....2
    .....2.............9............ROT............DC.......2.....3
    District, company, and model are all page fields that narrow the data.

    Here's how the pivot table is designed:
    .........Rental Type:
    .........One-way | In-town | Rotation | Total
    UD.........2............1............4............7
    PO.........1............2............8...........11


    Here's what I want: combine IT and ROT under the IT column, and add the % column. How do I do this since these are not separate columns in the spreadsheet? Or should I make them separate columns?
    .........Rental Type:
    .........One-way | In-town | Rotation | Total | Rotation % of Total
    UD..........2.............5............4..........7..............57%
    PO........1..............10...........8.........11.............73%

    The order of the columns is arbitrary, I just need the info.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Pivot Table formatting

    Try:

    select in town and rotation (i.e. the two cells with the names in)
    right click
    group and outline
    group

    let us know
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

  3. #3
    Registered User
    Join Date
    07-20-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Pivot Table formatting

    When I group the two columns, they just move next to each other under a sub-heading called group1 and puts the OW column in a group by itself.

    From this:
    .........Rental Type:
    .........One-way | In-town | Rotation | Total
    UD.........2............1............4............7
    PO.........1............2............8...........11

    To this:
    .........Rental Type:
    ...............Group 1............OW
    .........In-town | Rotation | One-way | Total
    UD.........1............4............2............7
    PO.........2............8............1...........11

    Nothing is summed together. I need to add two of the columns.

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Pivot Table formatting

    Double click the bit that says group 1


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1