Here is my Issue.
I have BEx report that displays amount data by plant, year, month, day and Doc No.
I want Avg on all the above objects as sub total.
Say : I have 3 doc # in 1 day. so the sub total is sum (3 doc amount) / 3.
but when i remove the doc# and 0calday from the report that sub total by month is not displaying correctly. It is displaying the very first record amount instead of the monthly average of all docs in that month.
same for the year and plant.
could you please explain the issue.