Sub Summary by multiple fields in one list layout
I have a list layout showing 'title of CD' in one field and then the royalty for this title in another. There are multiple records for each title with different royalty income.
What I need is to sort by CD title on this view and get all the separate records in a list showing the line by line royalty, however after each title I'd like a sub summary of the total royalty of each CD title.
Is this possible?