Forum Discussion
Unable to stop values field from calculating in pivot tables
Hello. I’ve created a pivot table where all the other fields are set up correctly. However I am unable to just include data in the “values” without it performing a calculation. Tried multiple times t...
A pivot table always summarizes the values of the field(s) in the Values area using one of the functions in the list (Sum, Count, Min, ...).
- Thanks, but now I'm curious what's the best way to just display the values. e.g. number of occurrences without counting? For example, display the number of repetitions performed with a certain load. If 30lbs, for 10 repetitions performed 4 times. What is the best way to report this?
The pivot table value fields counts but that's not what is needed.It would help if you could attach a sample workbook that gives us an idea what the data look like and what the desired result would be.
