Jun 06 2021 10:20 AM
Jun 06 2021 11:31 AM
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, ...).
Jun 07 2021 12:18 PM
Jun 07 2021 12:20 PM
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.
Jul 26 2021 12:06 PM
@3DGB1 Hello! Did you ever get this solved? I'm dealing with a similar problem where I just want the raw values and am using the pivot table to simply restructure the data (not perform a calculation).
Jul 26 2021 12:14 PM
@lfkane33 nope didn't find a solution and used R instead. If you're familiar with R, you can use GGPlots to segment/visualize the raw data, without calculations.
Oct 06 2021 12:04 AM