How do I make a pop up (rollover) in a pivot table without creating a character

[#1]

Hi All,

I searched to make a pop up and the best solution, without a button, is the chr (10) function, but it actually creates a space or character (because it is a chr function) and then values that are null appear (regardless of checking suppress missing/suppress zero-values).    I even tried to wrap the code in an if statement, example:  if(TotalValue = 0, 0, & char (10)....

Help please

Thank you.

Michelle

[Gysbert_Wassenaar]

Maybe like this: if(len(trim(TotalValue)), chr(10) & 'some text')