We have been working on this PivotTable for several minutes. Now is time for you to use what you have learned to add Max and Min fields to the PivotTable.
Our current PivotTable shows us the total and average number of samples distributed. We would like to see more information in this PivotTable. What were the maximum and minimum number of samples given away at any one visit?
Your finished PivotTable should look like this:
Use the following guidelines to add fields to your PivotTable.
Step1. Add the Samples field to the Values area.
Step2. Change the type of calculation to Max.
Step3. Add the Samples field to the Values area.
Step4. Change the type of calculation to Min.