Forum Discussion
Solved
Pivot Table Values
Hello. New to working with Pivot Tables and running into an issue when trying to add two different fields from my source data to the values section. I am creating a report to highlight the number of ...
- Hi Jan. Thank you for the offer to help. I actually kept googling last night and found an answer. I needed to change the field options from Count to Count Numbers. Once I did that for both values it solved the issue.
Thanks again. I appreciate the reply.
Can you upload a workbook which contains both a sample of your data and a sample of the expected output? Please make sure no sensitive data is included!
- Hi Jan. Thank you for the offer to help. I actually kept googling last night and found an answer. I needed to change the field options from Count to Count Numbers. Once I did that for both values it solved the issue.
Thanks again. I appreciate the reply.