Forum

Notifications
Clear all

Duplicate data in Pivot table

2 Posts
2 Users
0 Reactions
51 Views
(@ine)
Posts: 1
New Member
Topic starter
 

Hej. Would you please help me. The pivot table created is taking in consideration duplicate data. is it possible fix with out delete columns?

I would like to show only one data for column A / Transporte.

Thanks

 
Posted : 30/07/2021 6:50 pm
(@catalinb)
Posts: 1937
Member Admin
 

If the same value is repeated in a column, don't use the Sum aggregation, use Min or Max or Average, each will show only one of those values.

 
Posted : 31/07/2021 7:03 am
Share: