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.