Sort / Ascending-Descending

  • 22 August 2022
  • 1 reply


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.


Best answer by Keiran 23 August 2022, 10:35

View original

1 reply

Userlevel 3
Badge +2

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.