Pivot tables

Hello Richard

Thank you for your question.

If you select the box that represents the sales amount within the pivot table, or within the pivot table field list panel, then on the PivotTable Tools Options tab, click the Field Settings button (within the Active Field group).

You should be able to change Sum to Count as the function being used in the table within here.

I hope this helps.

Kind regards
Amanda