Hi Fabien,

I know we spoke separately but just so the community is updated;

In a Pivot if you are using a Relationship (A Dimension which has a relationship to a Dimension that structures the metric but is not directly part of the structure) then you cannot sort by that relationship.

For example, If you have a Metric structured by Country

And the Dimension ‘Country’ has a Dimension Property for ‘Region’, you can use this in the Pivot

You cannot use that Dimension Property in a Sort as it is not part of the structure of the Metric.

Hopefully this helps.