Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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