Pivot table

[TXdore]

Is there a way to divide one column by another column? For example, in my data source table, I have a column for project, category, costs, and sqft. i want category as rows, project as columns, and cost under values. BUT i want the per unit cost (cost/sqft), not the total.

i could add a column to the source table, but i want to use more than one unit type, like cost/acre, cost/month, cost/kw, cost/gallon, etc. is there a way, or do i just need to add all those columns?

[pb71]

Do you want something like a Calculated Field? E.g.

Name: Costs_Sqft

Formula: =IF(ISERROR(Costs/Sqft),0,Costs/Sqft)

Please see attached.

[TXdore]

Yes, that wound be better than adding columns to the source table.
But i assume i have to create a calculated field for each unit_type_measurement? Or is there a way to use a drop down or combo, either outside or inside the pivot table.