B
BorisS
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.
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.