We're making a database of all royalty payments from the last 15 years, and although its going well, we've hit a bump which we can't work out how to sort.
1 track of music can have multiple payment sources, and at the moment we can search for the track and get a grand total for how much it has earned. What we'd like however is to see how much each payment source has earned towards that grand total. ie:
Payment source 1 total - £20
Payment source 2 total - £50
Payment source n total - £100
Grand Total = £170
At the moment we just have the grand total.
The payment sources are part of a value list which is displayed as a drop down list - we want to be able to create totals for each different payment source on the value list for each track.
How do we do that? I've taken an example screenshot and can take more to give the relevant info. For this track there are only 2 payment sources, but as you can see they are made up of lots of smaller payments over time.
Thanks very much!