Forum

Pivot Table - How t...
 
Notifications
Clear all

Pivot Table - How to Have Unduplicated Column Entries

2 Posts
2 Users
0 Reactions
59 Views
(@michaelallan01gmail-com)
Posts: 1
New Member
Topic starter
 

Hi. Can you help? I've tried various iterations of pivot table arrangements but keep getting a count which is duplicated. The table is long and wide, but here's an example table:

 

NAME PURCH_ID SERVICE

MARY 1 apple

MARY 2 apple

MARY 3 apple

JEROME 4 orange

JEROME 5 orange

SUSAN 6 apple

SUSAN 7 orange

SUSAN 8 mango

 

I want to get a pivot table that provides unduplicated counts by consumer like this:

Apple 2 (Mary and Susan have apples)

Orange 2 (Jerome and Susan have oranges)

Mango 1 (Susan has mango)

 

I get a pivot table like this:

Apple     4

Orange  3

Mango  1

 

Thank you

 
Posted : 16/02/2023 1:58 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Michael,

Welcome to our forum. Take the Name field out of the PivotTable. Does that give you what you want? If not, please share an example file so we can see the before and after that you're trying to achieve.

Mynda

 
Posted : 16/02/2023 6:35 pm
Share: