I'm trying to calculate the standard deviation by different time intervals. My data table includes customer, sale date, product type, container date, lbs sold, and source plant.
I want to calaculate standard deviation for each row (rows are customers, products, and shipment container) across columns (in this case months 1...12,and weeks 1 ....52) with values being the pounds of product. I want to get a standard deviation calculated for each row across the month columns and the standard deviation needs to be done on the pivot results, not the source data. I also want to use in the calculation data from each month even if that data doesnt exist (i.e. if no sales for that customer for that product in that shipment container, consider that month sales of 0). This effects the standard deviation.
I'd share a table, but the problem is, its full of sensitive information and would take a long time to dummy. (unless you have a short cut way to dummy a table.)
Bookmarks