Retriving daily sales wwith GETPIVOTDATA function
Posted by Chuck Dickens on February 06, 2002 11:38 AM
I have a daily sales report on a different sheet that I want to pull pivot table data into. There are different products on the pivot table and the sales numbers are calculated by date. I want to be able to pull the "widget" sales for "1/1/02" from the pivot table into my report. When I format the formula using "1/1/02" and the widget as variables the formula returns the error value #N/A.
I can do this by referencing the cell from the pivot table in my report, but I think this formula would work better (with less mistakes)because what you are asking is more specific.