Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
salshute
Partner - Contributor III

Using chr(10) in a pivot table

Hi

I am wanting to list my values underneath each other within one cell of a pivot table. I am able to do this in a straight table but neither chr(10) nor chr(13) works in a pivot.

salshute_1-1690289732673.png

My expression is as follows:

Concat(If(Aggr(Rank(Avg(GapAnalysis_Score), 1, 1), GapAnalysis_Question) <= 5, GapAnalysis_Question), chr(10)).

Any assistance would be appreciated.

Thanks

 

Labels (3)
0 Replies