9 Replies Latest reply: May 8, 2013 6:46 AM by Jesper Juul RSS

    Pivot table background color in cells with no data

      Dear Sirs,

       

      I have a PL statement in a pivot table, and on one of my expressions i need a fixed background color.

      However, the background color formula does not apply if the cells has no data (marked with yellow in screen shot)

       

      How to fix?

       

      My data is both ODBC, excel and script-internal calculations.

       

      screenshot.JPG