Forum

Combine Duplicates ...
 
Notifications
Clear all

Combine Duplicates and Sum the result

3 Posts
2 Users
0 Reactions
185 Views
(@cc)
Posts: 2
New Member
Topic starter
 

Hi

Need some help see attched example of "result of a powery query" and "desired outcome of the query" being the next step

 

Colin

 
Posted : 07/11/2022 9:13 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Colin,

When you have a duplicate in the Selection column, how do you decide which to keep?  I can't see any logic to how this is chosen.  If you look at the Break Up column, how are the results here decided?

Regards

Phil 

 
Posted : 07/11/2022 10:41 pm
(@cc)
Posts: 2
New Member
Topic starter
 

Phil

All good I finally worked it by using the group by function

 

Colin

 
Posted : 08/11/2022 1:36 am
Share: