Hi
I have a table containing member IDs and credits allocated, which I want to periodically summarise and distribute to a staff member. The table will have the member IDs duplicated across multiple days, with different credit values, which I wish to sum, resulting in:
A. Smith 23
B. Jones 12
C. Young 75
I can create this output with a pivot table, but I need to be able to distribute it to a staff member automatically, without their access. I could send regular email/slack outputs but cannot get the summarise to work (perhaps with scripting).
Any suggestons?
Thanks