Hi elandrajo,

Welcome to Excel Fox !!!

A guess,

=IFERROR(IF(GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12")=0,"",GETPIVOTDATA("Sum of Total Price (converted)",$1:$1048576,"Sales Operations Location","US","Close Month","5/1/12")),"")