Repeating Group Category

[reubenk]

I looked at previous posts but have not been able to find a solution.

I have a database with some repeating data:

I am trying to display this data in a repeating group by “Color” so for example it would show number “5,2,1” with the “Color” “Red”

I am able to groupBy “Color” but all the numbers still show:

I must be doing something wrong with how the repeating group is set up. Any help is appreciated.

[mikeloc]

Hi there, @reubenk… with the way you have things set up (and if I understand your post correctly), a text element with the following expression will produce the desired result.

Best…
Mike

[reubenk]

Hi, @mikeloc

Thank you - this is exactly what I am looking for.