Group in groups?

1

Hi

Is there a way to group groups?

What I want is to count the sum of an item with same size in the same system

So if i have this:

System Size Count
A 20 1
A 20 1
A 30 1
B 10 1
B 20 1
B 10 1

I should end up with this:

System Size Count
A 20 2
A 30 1
B 10 2
B 20 1

I have tried groupbykey but dont know if thats the way to do it. Is it possible to group groups?

2

Hi @moeng

Yes that’s one way of doing…

862×672 38.8 KB

3

Try either of the below:

image
image.png1790×681 96.7 KB

1 Like
4

Thank you! That helped.