Thread: 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.

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.