Forum Discussion
JChadala
Apr 30, 2024Copper Contributor
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.
- AshaKantaSharmaIron ContributorIn 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.