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.

Hi ​@Fabien Bigeard,

Letting you know that we introduced the ability to sort List Properties and Dimensions from the header menu instead of opening the Sort panel - the latest up to date information on sorting in Pigment is here: