Solved

Sort / Ascending-Descending

  • 22 August 2022
  • 1 reply
  • 38 views

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.

icon

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.

Reply