Can you post a small snippet of data that I can play with. How did you want
to handle Accountants in both MI and WA. My experience with this is that
there is a lot of mix and match of data.
--
HTH...

Jim Thomlinson


"Jon in the U&L" wrote:

That is helpful, Jim. However, the result I am trying to get to will end
looking like this:

Pos Title Location Pay Plan Pos Series Grade FTEs
Accountant MI AA 1111 3 3
HR Spclst WA AA 0000 1 6

So on and so forth. When I run the Pivot Table I get a very ugly table that
stretches way out to the right to accomodate the series, grade, pay plan...

Maybe I need to keep plugging away at setting up the Pivot correctly.

Thanks, again.

"Jim Thomlinson" wrote:

Pivot tables allow you to move the fields around to get the best possible
representation of the data...

Here is a sample set based on your fields
Position Title Location Pay Plan Position Series Position Grade FTEs
A Here Small 1 1 1
B There Medium 2 1 2
C Here Large 3 1 3
A There Jumbo 4 1 4
B Here Small 5 1 5
C There Medium 1 1 6
A Here Large 2 1 7
B There Jumbo 3 2 8
C Here Small 4 2 9
A There Medium 5 2 10
B Here Large 1 2 11
C There Jumbo 2 2 12
A Here Small 3 2 13
B There Medium 4 2 14

And here is apivot table of that data...

Position Title A

Average of FTEs Position Grade
Location Pay Plan 1 2 Grand Total
Here Large 7 7
Small 1 13 7
Here Total 4 13 7
There Jumbo 4 4
Medium 10 10
There Total 4 10 7
Grand Total 4 11.5 7

Fields can be in Columns or Rows...
--
HTH...

Jim Thomlinson