- Why do you need "DUAL"? In the table, you only use the "Country" value (String side of the Dual)
If you need it for sorting purposes, don't forget you can set the order of each field in "By Expression". So, if your expression Aggr(NODISTINCT Sum([Actual head count]), [Business Unit], Country) is the order:
- The field should be just Country
- In Sorting, select these field, and click on "By expression", and in "Expression" box put your one.
If this expression is for order purposes, what is the order do you need?