Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I have attached a copy of the pivot table
Thanks for any help
Try this:
=count(if(len(<Dim>)=0,1,null()))