In that case instead of doing the pivot using the default activities you can use the linq approach for pivot