Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Add Fields to the PivotTable Report

There are 72 Bug Reports in the OriginalData. There are many reports for each department.

How many?

There are reports concerning different software problems.

Which software?

 

3. Add Fields to the PivotTable

Go to the Field List

Select Department

and Select Applications

 

You will see a new PivotTable on the left side of your spreadsheet.

PivotTable Tools ->Field List