=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