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...
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.
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.