Grouping with lookup is failing

Grouping with lookup is failing with the a SqlException and message “Invalid column name ‘Column Name’.”