1 Reply Latest reply: Feb 24, 2016 12:15 PM by Gysbert Wassenaar RSS

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

    michelle scullion

      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