This content has been marked as final. Show 4 replies
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
I tried not calculate null value. But it’s not work.
Would you share your wisdom ?