Skip to main content

Hi everyone,

I would like to display both Code and Name of a Dimension, in a Table.

Below is the objective which I created from screenshots:

In the first row, “CESSION” is the Name of the Code “AU1”, in the “Business Area” Dimension.

Thanks !

Hello again! 
What you should probably do is create a new property in the dimension where you concatenate the Code & Name. And then use that property as the new displayname. 

More info here: 

 


Hi ​@Matthieu Wallet ,

Step 1: In the “Business area” dimension, you’d need to create a property with formula:

'Business Area'.Code & " | " & 'Business Area'.Name

Step 2:  In the table, you can do the following steps:

  • Hover over to the row header in the table
  • Click on the dropdown
  • Click on the “Update Header Label”
  • Select the property name (which contains the concatenated name)

 


Reply