I am trying have data appear in the “Values” field in a pivot table, but the pivot table keeps summing the values that have the same date

by Rubin|Published May 17, 2023

In the pivot table, when there are two or more values assigned to a date, they sum.

I don’t want the values to sum. I want each value listed, even if the date is same for the values. I’ve tried going to “Sum of…” dropdown > Value Fields Setting, but it only gives me other operations like “Count”, “Average”, “Max”, “Min”, “Product”, etc.

Is there a way to stop the calculation and just let the values show for each date?