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

    Count blanks in Pivot - Show in text box

    nayan lalla



      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,



      pivot 2.JPG