I am having a problem trying to create data within a table using a calculated field where I need some sort of sumproduct(excel like) function to sum their amounts based on their group id. I've included a packaged workbook using an orchard example of oranges, apples and peaches. I think the answer is some sort of window_range function with a matching ids. I've been trying for days with no success
Can anyone help me please?