Now that I have the Sales Analysis working and giving me the correct numbers, it is only showing the very last item listed in each group. I have it set up as follows...
Page Header - Report Name
Group Header #1 - Group Name and all column headers
Details - Weekly sales formulas which I need to run totals on - supressed
Group Footer #1 - Item No, Description, UOM, QonH, QonSO, Base$, etc. AND the Sales Forecast (which is a formula calculated off the Weekly sales formulas and their sums)
Page Footer - Date/time/page no.
Can anyone tell me what I am doing wrong or missing to get all of my items to show in each group?