Hello! I have a couple of questions and then am happy to see if I can help you problem solve.
When do you want the aggregate column to update? For example, will this be a job that runs nightly to update the data or will the numbers update when a vendor logs into their dashboard to look? Or on some other site actions?