I'm trying to do a really simple pivot table: I have a table of employees'
names, pay periods, and total pay (total pay per pay period). Everything
goes fine until I drag the Total field to the Data section, then it changes
the name of the field to "Count of Total" and the data I get are numbers like
1, 2, and 3, instead of the amount of pay.

I haven't encountered this problem before when doing similar pivot tables.
What's happening, and how to I get it right?

thanx,
Cliff Perusse
San Francisco