Pivot Examples using SUM, COUNT, AVERAGE, Percentage of etc.
All the Pivot Table Examples are based on a data dump of mobile calls made over a three month period.
Create a Pivot Table based on the sheet ‘PhoneBill’ and then create the following reports. After each report refer to the solution sheet corresponding to the question number and see if your report looks the same.
1- A report showing the total duration (sum) for calls in January, February and March.
2- Change the data so that instead of seeing the sum of duration you see the average length of a call in each month
3- Change the data so that instead of seeing the sum of the duration you see how many calls were made (you will need to change the formatting back to a number)
4- Using the previous report as a base, create a report with the following data fields next to each other
a. The number of calls in each month
b. The total duration for calls in the month
c. The average duration per call each month
d. The percent each month makes up of the column (based on the duration)
e. A running total (cumulative duration) of calls for the months
f. The change in NUMBER OF CALLS per month from the previous month.
To see the full course contents click here.