A pivot table is a handy tool for estimating projects.
Fields
The source data in the example contains three fields:Area,Item, andCost.
The pivot table as shown uses only two of these fields:AreaandCost.
Pivot table project estimate
A pivot table is a handy tool for estimating projects. As long as the data is well structured, a pivot table can easily handle hundreds or even thousands of line items. You can group these items by category, by phase, by contractor, and so on.
