Need a little help on each of these steps. If anyone can give somewhat of a step by step analysis it would be appreciated.
1. Create a pivot table in a new worksheet called “Data Analysis”
2. Make the background the same Tan color (there is a trick to this that involves a new worksheet and come cutting and pasting)
3. Change the view of the Pivot table to be “Classic Pivot Table layout...”
4. Provide a count of documents by Critical Operating Process for each of the roles. Please note that the totals at the bottom match the totals you calculated in the data table using the Counta formula
5. Change the columns headings for the data columns to run up at a 45 deg angle, delete the words “Count of” and add the “(Tot)” at the end of each one.
6. Notice the “Document” Row in the picture below. Add that row as pictured below but hide the information to keep the table only showing totals by Critical Operating Process Name. Notice what happens to formatting of your background when adding rows and then hiding or removing them.
7. Remove the Document field from the Pivot chart and fix the background color. Create a Pivot chart from the pivot. Choose a 3D stacked bar chart. The corresponding chart will show which role has how much involvement with each Critical operating process. Using this chart it is easy to see which COP’s are not relevant to the AP Market Manager. This chart also shows that the Operations Manager is very involved with all of these processes.