4 Replies Latest reply: Sep 1, 2016 3:32 PM by KHOA NGUYEN RSS

    SUM ALL/TOTAL, disregard show null settings

    KHOA NGUYEN

      I have a calculation that depends on getting the correct value of SUM(TOTAL <Dimension01> Field01).  I have a pivot table that displays `Dimension02` that can have NULL values.  I want to hide the NULL values, but still get the correct sum of `Field01`.  How do I achieve this?

       

      SUM(TOTAL <Dimension1>

      SUM ALL TOTAL <Dimension1>

      SUM({1}

      SUM(ALL

      SUM(TOTAL <Dimension1> {1}

      etc...

       

      My sum is very much dependent on the Show Null Values setting.  I want to disregard it.