Pivot Table use dimension as an expression

[#1]

Hi,

For a particular use case in my dashboard, I need to use a dimension as an expression in a pivot table, but when I use the dimension as an expression I don't get any results. For example: a dimension [Course Title] displays vale 'abc' when used as a dimension but when I used the same dimension as an expression using the formula =[Course Title], I get only '-'

Kindly advise!

[sunny_talwar]

May be there are more than one values... to check if this is true or not, try this

Concat(DISTINCT [Course Title], ', ')

[#3]

Still does not work

[Anil_Babu_Samineni]

You have only one Expression in Pivot Table. If it is string you must check the Suppress from Presentation tab

[sunny_talwar]

Can you show us what you are seeing?