pivot count
 

I have a pivot table which has two row groups (state, rep), and then several
pieces of data (about 5), so each group is state, rep, then the five pieces
of data. Horizontally, I have 5 quarters shown.

The data is all calculations (average, max, min, etc.) of one of the amount
fields in my data. What I need, however, is to have a per state count of
number of reps. Any ideas?

To make it clearer, the challenge is that I cannot put the rep field in as a
data field, since it's already a row field. And when I go to the Rep field
settings, and set the count as the function to perform, it ignores that, I
guess because it's a row field.
--
Boris

pivot count
 

You can add the rep field to the data area although it is already a row
field. It can be in both, and by default will count the number of reps.

Hope this helps,

Hutch

"BorisS" wrote:

I have a pivot table which has two row groups (state, rep), and then several
pieces of data (about 5), so each group is state, rep, then the five pieces
of data. Horizontally, I have 5 quarters shown.

The data is all calculations (average, max, min, etc.) of one of the amount
fields in my data. What I need, however, is to have a per state count of
number of reps. Any ideas?

To make it clearer, the challenge is that I cannot put the rep field in as a
data field, since it's already a row field. And when I go to the Rep field
settings, and set the count as the function to perform, it ignores that, I
guess because it's a row field.
--
Boris