# Pivot Table - Calculating Percent of Cost Type In Column next to Grand Total

#### stlee

##### New Member
I have a pivot table and I want to create multiple columns that will end up like the table below (on the right, left is sample data). My data has date processed for each line so I can do a date sort, but I can only do one column at a time(e.g. rent, then copy it, then resort the table for grand total, then manually make a new percent column). Is there a way to set it up so I have My data separated on a year-to-year basis but have that year to year start on 7/1/? Maybe calculated columns?

 Sample Data Date Processed Cost Type Amount FY 2010 Grand Total FY 2010 Rent FY 2010 Rent % FY 2011 Grand Total FY 2011 Rent FY 2011 Rent % 10/11/2010 Rent \$ 47,882.00 \$ 134,299.00 \$ 47,882.00 35.65% \$ 72,503.00 \$ 20,978.00 28.93% 10/12/2010 Materials \$ 86,417.00 10/14/2011 Materials \$ 14,638.00 10/15/2011 Materials \$ 16,207.00 10/16/2011 Rent \$ 20,978.00 10/17/2011 Labor \$ 20,680.00

<tbody>
</tbody>
Thanks

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Replies
5
Views
624
Replies
4
Views
923
Replies
0
Views
195
Replies
1
Views
357
Replies
4
Views
310

1,206,833
Messages
6,075,126
Members
446,123
Latest member
junkyardforme

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back