98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Pivot tables
Resolved · High Priority · Version 2007
Mon 6 Jul 2009, 21:23Delegate Richard said...
Richard has attended:
Excel Advanced course
Pivot tables
How do you change the valus in a pivot table from sum to count. i.e you want to see how many cars were sold, rather than the value of the sold cars.
Tue 7 Jul 2009, 09:10Trainer Amanda said...
RE: 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Missing Field handleIf your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. |
