GETPIVOTDATA count column when =0

[drom]

Hi and Thanks in advance

I have a Pivot Table.
This pt shows 2 columns: Countries and Sales.

Country is a Row field and then I show Count of Sales on the right of Countries.

Now I would like to add GETPIVOTDATA formula and get how many countrie's Sum is equal to zero.

GETPIVOTDATA ("Sales";$a$4;"Sales";0) Does not Work.

Any IDEA???

This eg is just for this query, I have to use a Formula and if possible GETPIVOTDATA

 

[taigovinda]

In order to use getpivodata() to get info for a particular country, you would need to supply that country's name. Therefore, I expect getpivotdata() is not the way to go here.

What would probably be the easiest is countifs() (post Excel 2003) or sumproduct() (2003 and below). You would need to count the rows where the country column is non-blank and not a total/subtotal and where the sum column is equal to zero.