bradleyjohnrob
New Member
- Joined
- Apr 16, 2015
- Messages
- 1
I'm trying to get a 52 week sales/inventory report to auto fill from a data dump in the form of a pivot table. The only problem is that if there is no sales data from a week then that week does not show up in my pivot table because of the lack of source data. For example if there were no sales in week three and I made a pivot table grouped by week then there would only be three lines of data. I've unsuccessfully tried using a lookup function to fill the data in.
I've looked into the getpivotdata function, but I don't know if that will help me at all.
Is there anyone that has run into this problem and found a fix?
I've looked into the getpivotdata function, but I don't know if that will help me at all.
Is there anyone that has run into this problem and found a fix?