We need to calculate the average sales for each item.
But then we need a sum of all the averages in the total of the report.
Solution:
- Calculate average per item normally
- Create a footer on the item group
- Use the avg function in a runningvalue formula in the footer to get a running total
- Using visibility code, Only show the footer for the last item
No comments:
Post a Comment