How to format the tooltip on a vizlib pivot table?
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?