Pivot Table - field to appear as actual text in measure column

[tvisha]

Hi,

I have a pivot table. One of the fields is notes, which is a dimension. I want to display it along with measures , but not as sum or count, the actual notes, is there a way I could do this?

Sample screenshot attached

Thank You, 

[Or]

You could use Only() if there is always one value. If there's more than one potential value in a cell, you could use Concat(), MinString/MaxString, or whatever other function you want depending on what the expected outcome is.

[tvisha]

Will Only() work in set expression, how do I use it, sorry new to this so

[Or]

Only() is an aggregation function, so it will take a set expression. It returns either a single value (if one exists in the context it is used) or null (if no values exist, or if multiple values exist). Check the documentation for additional information.

[tvisha]

I did check the documentation.

The pivot table is aggregated based on Accountname and it takes the max id. For each of the columns it has 1 unique note. I am not sure if this will work.