View Single Post
 
Old 10-11-2023, 12:01 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 358
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Hi, I think you just need to change the field value you're going for in the Values quadrant. Where it shows Sum of (value) (circled in the left side of the pic) you should be able to right click on that and find the Value Field Settings. Simply change from Sum to Count or any of the other options given.
Attached Images
File Type: jpg pivot-table.jpg (74.4 KB, 8 views)
Reply With Quote