Forum Discussion
Is it possible to show values only once in a pivot table?
I'm starting to question weather this should all be in one pivot table...but I have a pivot table that looks like this: col_1 col_2 col_3 value_1 value_2 TEAM unique_ID JOB salary OT i...
In the PivotTable, use the Value Field Settings to aggregate values like using Max, Min, or Average. For example, if you only want to show the OT value from the first instance, you can set the summary function to Max or Min depending on the specific requirements.
