Pivot Examples: rows in a pivot table

Please purchase the course before starting the lesson.

Pivot Examples: rows in a pivot table

1-    Using the available pivot as a base create the report that:

a.     Brings the day of the week to the right of the Month

b.     Sort the day of the week so that it reads Monday to Sunday

c.     Remove Saturday and Sunday from the report

d.     Move the Average Duration for a call to the first data column

2-    Using the above as a base:

e.     Remove all the data columns except for the Average Duration per call and the Total Duration per call

f.      Create Custom subtotals on the MONTH to show:

i.    SUM

ii.    COUNT

iii.    AVERAGE

iv.    MAX

v.    MIN

g.     Change the Layout to show in Outline Format

h.     Insert a blank line after each item

To see the full course contents click here.

 

Back to: Intermediate Excel Course > Pivot Tables