cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ckserra
Helper III
Helper III

GroupBy or Distinct

Hi everyone.  Struggling on using either groupby or distinct to get a solution to my problem.  I have a sharepoint list that shows items sold.  I am trying to simply rollup up the items sold and sum the quantities sold. My data source closely resembles the table below.

button3
switch5
monitor8
laptop1
button2
monitor9

 

Looking to simply distinct the first column and sum the second based on the first.

 

Thanks for all the help!

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
BCLS776
Super User
Super User

A groupby with an addcolumns + sum works well on what you're trying to do here. Have a search on here for some examples.

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
BCLS776
Super User
Super User

A groupby with an addcolumns + sum works well on what you're trying to do here. Have a search on here for some examples.

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

ckserra
Helper III
Helper III

That helped, thank you very much!  Ended up using this as my final formula.

Sort(GroupBy(DepotPlacedOrders,"Part","DATA"),Part,Ascending)

 

Thank you again!

Chris

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,540)