I have some dimension data which I have flattened into one table and I am trying to add sort by column into the model, but I keep get the error
“Cannot sort KPA Description by SortOrderKPA because at least one value in KPA Description has multiple distinct values in SortOrderKPA. 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.”
I actually want to be able to sort by the KPA Description by the KPA Position, Outcome Description by the Outcome Position and the Activity Description by the Activity Position.
I’ve tried creating unique sort orders, but nothing seems to work. Any help would be appreciated.