We have a table we’ve created where we need to bring a SUM of multiple records in another table over. For instance, we’ve grouped users in TABLE1 which then shows us the SUM spent for that user. In TABLE2, we want to show the SUM of that group in a field so we can export it with the additional information contained within TABLE2.
Any ideas?