Forum Discussion
Solved
split column and then count
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?
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
