Pivot Table - Row subtotals

[Alex Mackenzie]

I have a pivot table with two row fields, say Field1 and Field2. The pivot
table subtotals (sums) the rows for Field2. Rather than sum, I would like to
just have a count of the number of rows (counta). Is this possible and if
so, how do I setup the table to generate this result?
Example of what I want to do:

Field1 field2a 1
field2b 2
field2c 3
Field1 count 3 (not 6)

Thank you.

 

[Luke M]

Select the subtotal field you want changed, right-click, go to field
settings. Select Count as the function you want to perform.

 

[Alex Mackenzie]

I went to the Field1 count field, right clicked, selected "custom" radio
button and clicked count; the result did not change, still get the sum.
(Selecting a different function, such as MAX, and the results do change).
Not sure why the results do not change; using EXCEL 2000. Any suggestions?
Thank you.

 

[Debra Dalgleish]

The Count function doesn't count the rows in the pivot table, it counts
the records in the source data. Perhaps there are 6 records, so the sum
is the same as the count.