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

[stlee]

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?



[TABLE="width: 977"]
<tbody>[TR]
[TD]Sample Data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date Processed[/TD]
[TD]Cost Type[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD]FY 2010 Grand Total[/TD]
[TD]FY 2010 Rent[/TD]
[TD]FY 2010 Rent %[/TD]
[TD]FY 2011 Grand Total[/TD]
[TD]FY 2011 Rent[/TD]
[TD]FY 2011 Rent %[/TD]
[/TR]
[TR]
[TD="align: right"]10/11/2010[/TD]
[TD]Rent[/TD]
[TD] $ 47,882.00[/TD]
[TD][/TD]
[TD] $ 134,299.00[/TD]
[TD] $ 47,882.00[/TD]
[TD="align: right"]35.65%[/TD]
[TD] $ 72,503.00[/TD]
[TD] $ 20,978.00[/TD]
[TD="align: right"]28.93%[/TD]
[/TR]
[TR]
[TD="align: right"]10/12/2010[/TD]
[TD]Materials[/TD]
[TD] $ 86,417.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/14/2011[/TD]
[TD]Materials[/TD]
[TD] $ 14,638.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/15/2011[/TD]
[TD]Materials[/TD]
[TD] $ 16,207.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/16/2011[/TD]
[TD]Rent[/TD]
[TD] $ 20,978.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/17/2011[/TD]
[TD]Labor[/TD]
[TD] $ 20,680.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks