Forum Discussion

JChadala's avatar
JChadala
Copper Contributor
Apr 30, 2024

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

 

in my pivot there will be "duplicate rows", for example.

 

Team 1  ID100 Job 1  $20,000 50

  "             "      Job 2  $80,000 50

 

The 50 is coming from a separate OT table and is linked by unique ID not by job. So i get why it's showing twice. Is there any way to have it show for just the first instance? The total at the bottom is only 50, which is accurate. Not sure if there is a formatting/display solution or if I need to edit OT table.

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

Resources