I am trying to show my data in a pivot table and have a)selected the data i want, b)got the rows and columns how i want them, but, all my values (selected max) are at zero when i know the values aren't zero. Please help

Hi FrancescaGould.

Based on your description, I created a simple Pivot Table as shown in the following figure.

I didn't get your result, it worked fine in my own environment.

I suggest you refer to this video about how to use MAX Value in Pivot Table:
https://www.youtube.com/watch?v=hO_2nxRcpZg

If possible, please send a screenshot and a sample file to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su