Hello. I have dates of Jan through Sepember by Product by month. I use this formula to get the average.
AVG({ FIXED [Category], [Date]: SUM([Sales Volume])})
I need to figure out how to identify the first date of a product (the first data that sales are > 0 for the period) and then use that to adjust JUST that specific month of data.
I guess the idea would be to look through the period and determine the first point where that product has a value > 0 and then use that position and subtract from last day of the month to get the divisor.
Additionally, I need to eliminate the months that have 0 out of the yearly daily average.
Can someone help with this?
Alex,
Can you just filter out at the data source for all rows where sales equal 0 for a product?
A sample workbook is needed to assist much more.
Thank you
Patrick