sum accross tables
I do have two tables 1. artists and 2. artistic works with a 1:n relation, that is one artist can have many works. There are costs associated with each artist, eg. accomodation, travel and with each work, eg. setup costs, fees, packaging.
I'm having two kind of sums: One sum for all artist related fields and one sume for each work related fiels. Now I'd like to create a layout where the main sorting is artists and where I'm getting a total for each artist with his/her associated works.
by using the function sum (total_artist;total_work) I'm getting the sum of the artits and of the last work, but not of the artist and all works.
See attached screenshot. If you need any additional information, let me know. Thanks in advance.