Pivot Tables
 

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

Pivot Tables
 

Count is the default function a pivot table uses. To change it to a sum:
- right-click on the "Count of Total" field name.
- select Field Settings
- in the Summarize By listbox, select Sum
- click OK

Hope this helps,

Hutch

"SFTaxMan" wrote:

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

Pivot Tables
 

thanks a million, Tom. I was sure somebody would know the answer of the top
of his head.

Cliff


"Tom Hutchins" wrote:

Count is the default function a pivot table uses. To change it to a sum:
- right-click on the "Count of Total" field name.
- select Field Settings
- in the Summarize By listbox, select Sum
- click OK

Hope this helps,

Hutch

"SFTaxMan" wrote:

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