After spending some time with support and going through all the options.
It looks like the option of: Sum By Company And Campaign would fit my needs.
However that looks at the payment company and the payment campaign. Would we be able to have an option that looks at the charge?
The option of Sum By Company/Campaign of Charge And Class would not work for us since that does not use the classref for the campaign, rather as the income account.