I figured out how to use a self join relationship to get a sum total of the debit part of transaction table (includes credits and debits). How do I add it to sub summary sorted by date so the sum total of debit transactions for date is displayed instead of the sum of debit transactions for all days?
I want the total production to be per day not in total as it is shown in this summary report sorted by date.
Self join relationship is based on global field value of "debit" which = the field value of debit in table.
Total Debit = sum (self join debit::transaction amount ) --> $585