Adding up null/blank value from a Pivot Table in a KPI

[Bradlabs12]

I am little new to this product , so hopefully I describe my problem clearly.

I am trying to create a KPI that looks at a pivot table for any time a columns has a blank/null value. 

• If there is a blank/null value anywhere within the column then that column should be counted in the KPI

I have attached a copy of the pivot table

Thanks for any help

[Arthur_Fong]

Try this:

=count(if(len(<Dim>)=0,1,null()))