A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello,
Welcome to Microsoft Community and thank you for posting your query.
Since you are using Pivot table, you may post your query in Excel IT Pro using the forum link below for better suggestion.
https://social.technet.microsoft.com/Forums/office/en-us/home?forum=excel
Hope this information is helpful. Please feel free to reply in case you face any other issues with Office in future.
Thank you.