Group by sportsvenue and get sum of each group

Hi experts, I am having issue on how to group matching venues and get the sum. Please assist image
So that I have a pivot dt
Texas 14900
Chicago 20000

maybe you are looking for this:
grafik

input/output:
grafik

Refer also to this:

1 Like

Alright ppr, that’s what I want, I still have more question to share too

Perfect
Just close the topic after final testing with marking the solving post as solution, in case of it was passing the test. Others can benefit from it. Thanks

depending on the questions feel free to open a new topic on it. Maybe the questions can be brought in a direction that we can help you on learning of particular concepts. So you will get quickly independend and can solve the cases.

Ok, marked as solution thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.