jasonr704
11-30-2010, 04:25 PM
what's the best, easiest way to just return a "0" instead of N/A's when referencing data in a pivot table? what should I add to my formula below?
here's my current pivot table reference:
=GETPIVOTDATA("Sum of Component Total",'Bing-Rev'!$A$3,"Order date",DATE(2010,11,1),"Type","order_line_item")
Thanks!
here's my current pivot table reference:
=GETPIVOTDATA("Sum of Component Total",'Bing-Rev'!$A$3,"Order date",DATE(2010,11,1),"Type","order_line_item")
Thanks!