4 Replies Latest reply: Jun 13, 2018 11:02 AM by nayan lalla RSS

    Count blanks in Pivot - Show in text box

    nayan lalla

      Hi,

       

      Is there a way to count blanks in a pivot and display the answer in a text box.

       

      In my screenshot below, how do I count the blanks (those circled in blue) ?

       

      My formula for the expression is as follows

      if(Sum(Sales) <=0, chr(10007),' ')

       

      Kind regards,

      Nayan

       

      pivot 2.JPG