Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tvisha
Creator II
Creator II

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

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

 

tvisha_0-1667919451287.png

 

Thank You, 

Labels (1)
4 Replies
Or
MVP
MVP

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
Creator II
Creator II
Author

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

Or
MVP
MVP

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
Creator II
Creator II
Author

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.