
grumelo.com
Grumelo's RealmSharePoint multiple values field in Pivot. Posted by: Grumelo in SharePoint. How to deal with SharePoint (or MS Access) choice column, multi-value field (lookup field, person field) in Pivot or even PowerPivot? How to split, expand, explode multi-value fields and use them in Excel reports? Analyze SharePoint multiple values field in an Excel pivot table. The solution must be automated, not manual execution of a script or macro. Or even worst if it’s a lookup:. Person 1 ;#125;#Person 3;#68;#Person 4;#122.
http://www.grumelo.com/