Cannot order '%{table/}'[%{column/} by %{orderbycolumn/} because at least one value in %{column2/} has multiple distinct ...

Cannot order '%{table/}'[%{column/}] by [%{orderbycolumn/}] because at least one value in [%{column2/}] has multiple distinct values in [%{orderbycolumn2/}]. For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region.