The PivotTable Options Dialog allows you to specify specific values to show
for empty cells or for error value.

Would setting a '0' as the value to show when no data exists do what you want?

HTH,

TK

"gongxia649" wrote:


=GETPIVOTDATA("NetSales",data!$A$1,"trans_date",C3 3,"store_code","023")

trans_date is the date in the transaction, c33 is the date. But i have
no date which i can reference to, because of that it's displaying
#ref!. i want it to be '0' instead. how can i get around this?


--
gongxia649
------------------------------------------------------------------------
gongxia649's Profile: http://www.excelforum.com/member.php...o&userid=35346
View this thread: http://www.excelforum.com/showthread...hreadid=551186