How to format the tooltip on a vizlib pivot table?

[jaipersr]

Hi Everyone,

I am trying to add a tooltip onto a measure that is within a vizlib pivot table. I would like the tool tip to contain two measures. Lets say measures X and Y. I don't have an issue displaying the two number because I just use  '=X&Y' to concatenate the output. I would like to put them on different lines which I am having trouble doing. I would like my out put to look like the following:

X

Y

I have already tried to put '=X&CHR(10)&Y' and '=X&CHR(13)&Y'. The CHR() function seems to only add a space character. Any thoughts on how to add a new line character?

[Arcticat500]

I know this is an old question, however, I also struggled with this in a concat( expression for the tool tip and never found documentation on it. Today I accidentally discovered a solution, however!

To give the two row result, '=X&'<br>'&Y'

For a Concatenation delimiter (so multiple results appear on their own line), use Chr(10)&'<br>' as your delimiter, and now your results get a carriage return at end of each value.