Hello,
I want to sort a table by descending or ascending, depends of my metric value.
I don’t succeed. could you help me please ?
Thank you in advance.
Best regards.
Solved
Sort / Ascending-Descending
- Trendsetter
Best answer by Keiran
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.
+11- Employee
- Answer
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.
Keiran | Pigment Specialist (Head of Support, EMEA)
+8- Wallflower
Hi
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.