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.
Bookmarks