Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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