On second thought let me go ahead and attempt to explain the rest of the process.
-Next un-select #DD through #Adviser.
-Pull the fields District Director through Adviser into the Values window just as you did into the Row Labels.
-If you want to change the column heading of Count of Division Director to #DD select the column heading (E4) and type in #DD.
Notice that in the copy of your file I put in post #2 I changed the names slightly so that the pivot table would give a count of different individuals holding the positions. That may or may not be the situation, I was just making a guess.
Bookmarks