Forum Discussion
Pivot Table not displaying all the data.
- Good morning,
Thank you for the suggestion. I followed the instructions in the link, however there was no option for Show Values As as indicated in the solution.
I confirmed that the field settings subtotals were set to none. In the end, I found that if I chose expand field for all of the "missing" data that it displayed. I've run an update since and it does not seem to have reappeared at this time.
Thanks
Hi ToddTranservice,
it appears that the pivot table is not displaying all of the data because the "Show values as" setting is set to "Sum". This setting will only display the sum of the values in the value field for each row and column.
To display all of the data, you can change the "Show values as" setting to "Count", "None", or another appropriate calculation.
To change the "Show values as" setting, right-click on the value field in the pivot table and select "Show Values As". Then, select the desired setting.
Here is a link to an article that explains how to change the "Show values as" setting in a pivot table:
How to change the "Show values as" setting in a pivot table: https://support.microsoft.com/en-us/office/show-different-calculations-in-pivottable-value-fields-014d2777-baaf-480b-a32b-98431f48bfec
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
- Good morning,
Thank you for the suggestion. I followed the instructions in the link, however there was no option for Show Values As as indicated in the solution.
I confirmed that the field settings subtotals were set to none. In the end, I found that if I chose expand field for all of the "missing" data that it displayed. I've run an update since and it does not seem to have reappeared at this time.
Thanks