Aggregate Record Data

Hi,

I have record data as shown in the table below : 

Id NumbersInText
1 One
2 One
3 One; Two
4 Two; One
5 One; Three; Two
6 Three
7 Three
8 Two
9 One; Three

I am trying to aggregate this data is such a way that I can how the report below :

NumberInText Count
One 6
Two 4
Three 4

Please help me with it.

  Discussion posts and replies are publicly visible

Parents Reply Children