in window Choose fields to add to report the box is checked. On left, the value fields are listed next to a window Drop Value Fields Here. When dragged into it the cells remain empty. ............ Excel 2010 family on Win 10 laptop

You also have to drag the field to the "Values" area. By default it's probably the Count function that appears. If not, right click on it and change the function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

... That the problem. It's not allowing me to drag the fields into the "Values" area.

Can you post the sheet itself (no pics) - Click - Go advanced - Manage attachments

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

friends.xlsx ............ I could not find "Go advanced", but "Attachments" seems to work.

FYI "Go advanced" is the button under the window that opens when you click the " Quick reply" button.
This being said, everything works perfectly

Attached Files

friends.xlsx (22.0 KB, 9 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post