formula to total then divide field
I have what seems like should be an "easy" problem to fix. I just cannot figure it out. But I know someone has ran into it before so I reach out to the oh-so intelligent community :) I have a sum...
Forum Discussion
Do you just need to summarize by week or is it by like product by week? If its just by week, then you load up a table with all the Sundays for the next 10 years, using excel.
The alternative to to populate the summary table by manually copying a summary report which creates a concatenated Key field of the Summary you need to do, like YYYYMMDD-Name
The alternative to to populate the summary table by manually copying a summary report which creates a concatenated Key field of the Summary you need to do, like YYYYMMDD-Name