I have a cross tab report that reflects annualized project cost elements for a work package that may encompass multiple fiscal years. For example....
COST ELEMENTS FY11 FY12 Total
Labor 15,000 25,000 40,000
Supplies 1,000 5,000 6,000
Consumables 100 200 300
Then we add certain overheads to the ENTIRE WORK PACKAGE. Note they are noot annualized. For Example
Telcomm 125
PC 500
GNN 2,500
Contracts 100,000
So the Totals I need to report are:
FY11 FY12 Total
16,100 30,200 148,925
I need to know how to add theese overheads to just the "Totals" Column.