The Pivot table

a. Using the PAYROLL table, prepare a Pivot table that displays the following as columns:
– Gross pay
– Employee fica
– Employer fica
– Federal tax withheld
– State tax withheld
– Net Pay
Below the columns all values will be summed up as totals.

Using the PAYROLL table, add the following rows to the above Pivot table:
– Jan
– Feb
– Mar
Add emp # as a Pivot filter.

b. Using the Pivot table data prepare a Pivot clustered column graph that depicts:
– Jan data
– Feb data
– Mar data
Each month in column style bar graph, vertically with legend.










Sample Solution