What kind of data source did you use? Excel file or other data source?
Did you check if there are one more data fields in list?
How did you create the PivotTable? Did you use Power Query?
I suggest you copy the data source table to a new Workbook and create a new PivotTable.
Try to provide more information or screenshots about this problem, I'm glad to help you.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.