Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to 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
@jcastr02
In your case, you can use end brack ")" as the delimiter, in stead of comma.
Paul
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