Howdy,
Pivot Tables are a bit of a hole in my excel expertise. I know how to use them, but not very well.
The sample sheet below shows a summary row of calculations based on counts of TRUEs and FALSEs in the data. It actually counts 1s and 0 in columns J through M because I do some error catching as well. The Percentage Complete is based on those counts AND the weighted numbers shown above each summary header.
Works great, except now the boss want to see those summary calculations separated by Area (column B). My first thought is pivot tables! Question is how do I get those summary calcs into a pivot table for each area? I saw a post about inserting calculated fields into a pivot table (Formulas...Calculated Field) but I don't seem to have that function available to me (I run Excel 2002).
Any thoughts?
Pivot Tables are a bit of a hole in my excel expertise. I know how to use them, but not very well.
The sample sheet below shows a summary row of calculations based on counts of TRUEs and FALSEs in the data. It actually counts 1s and 0 in columns J through M because I do some error catching as well. The Percentage Complete is based on those counts AND the weighted numbers shown above each summary header.
Works great, except now the boss want to see those summary calculations separated by Area (column B). My first thought is pivot tables! Question is how do I get those summary calcs into a pivot table for each area? I saw a post about inserting calculated fields into a pivot table (Formulas...Calculated Field) but I don't seem to have that function available to me (I run Excel 2002).
Any thoughts?
ModelTrack.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
5 | Equipment | ||||||||||||||
6 | As of Date: | 08/02/2007 | |||||||||||||
7 | % | 50 | 60 | 95 | 100 | ||||||||||
8 | Type | Percentage Complete | Totals | Day | Preliminary | Vendor Preliminary | Verified | Final | Errors | ||||||
9 | EQUI | 61.82 | 198 | 8 | 110 | 51 | 4 | 33 | 0 | ||||||
10 | 0 | 0 | 0 | 0 | |||||||||||
11 | Tag | Area | Class | Type | Preliminary | Vendor Preliminary | Verified | Final | Errors | ||||||
12 | /26-AR-001 | 26 | MECH | AR | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
13 | /26-BH-903 | 26 | MECH | BH | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
14 | /26-CH-001 | 26 | PLTW | CH | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
15 | /26-CR-001 | 26 | MECH | CR | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
16 | /26-CV-001 | 26 | MECH | CV | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
17 | /26-EF-904 | 26 | MECH | EF | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
18 | /26-FE-001 | 26 | MECH | FE | TRUE | TRUE | FALSE | FALSE | 0 | 1 | 0 | 0 | |||
Equipment |