0 Replies Latest reply: Feb 18, 2015 11:58 PM by Nick Listerman RSS

    Populating missing data for dates where product / department / location have no volume

    Nick Listerman

      I was able to get a good answer from this community when I only needed to populate missing data for product and date but now I need to improve my data set.  I've attached example files.  I'm trying to populate this missing data in order to accurately calculate average and standard deviation for products, departments, and locations over a given timeframe.

       

      I need to be able to populate a table with every combination of Product, Department, Location, Date, and Volume.  For every product I should have every department, every location, and every date, showing zero if volume is not found.  Make sense? 

       

      Previous post with just product, date, and volume: Populating missing data for dates where product has no volume