4 Replies Latest reply: May 31, 2018 2:03 AM by P Kumar RSS

    How to exclude null value in KPI or Pivot table.

    Jenna Jo

      Hi, All

      I’d like to make KPI or Pivot table without Null value.

       

      Example filter is as below.

       

      I want to collect # of Status : Active, collect only if Certificate # (Column B) has value.

      In this data, Value should be 3. Because Row 5 has no value.

       

      But when I tried to make table, it show value as 4, including null value. Even I didn’t calculate.

       

      Status – Active : 3


       

      캡처.GIF

       

      I tried not calculate null value. But it’s not work.

      Would you share your wisdom ?

       

      Thanks!