split column and then count

[jcastr02]

Hello, 

I have a line of business column coming into a sharepoint list and the user can pick multiple requests if the request impacts various lines of businesses.  I'd like to be able to get counts of each of the lines of businesses.  I've attached a screen shot.  After I split the columns into individual columns, how could I get a count of each line of business?

[Anonymous]

@jcastr02 

In your case, you can use end brack ")" as  the delimiter, in stead of comma. 

Paul

[jdbuchanan71 · Accepted solution]

Hello @jcastr02 

Once you have split the column into multiple you can unpivot them all to get one long list.  Then you can count the number of lines in table for each LOB