Have a look at the "GetSummary" calculation. You're probably looking at something like:
GetSummary ( Products_Total ; ProductID ) / 100
When you sort by ProductID, you should get what you need.
Thank you for your reply !
The Getsummary works great for the Grandtotals, but not for the Subsummaries which is the same calculation, any idea?
If what I suggested works only for the Grand Totals, then I have misunderstood the structure of the report. In the table occurrence for the report layout, is it one record per product, or multiple records per product? If it's multiple records per product, then what I wrote should work, provided that you sort by product. The sort is important, otherwise the summary won't work.
Unless I have totally forgotten how the GetSummary calculation works...
1 of 1 people found this helpful
Have you tried using a Summary field instead of GetSummary? That will deliver a result on each subsummary part, depending on how the part is sorted, as well as giving and overall total in a trailing grand summary.