Well, I am not sure, but I would setup a different relation/TO for this and use a SUM(...) calculation instead.
Mmm, thank you for your answer.
But can I define the SUM calculation in a way that it will only add values from one specific end product (so in essence: define a break field within the SUM calculation)? And how exactly would you make the relation than? I have placed the file on my MobileMe account, at http://public.me.com/b.bijl, so please elaborate on it a little more if you want to.
Thank you for your post.
The SUM calculation will work on a portal, so if you want it for each product, you'll need to set up a separate table occurrence for each end product.
Another method would be to loop through each product, and when the product changes, add a record to the other table, set the field values, and return to the original product table and proceed through the next product until the end of file has been reached.