SuiteAnalytics Data Duplication

Trying to figure out a way to remove duplicates. I need to pull all invoices and then show how they were paid and the amount of every line item (Main line has to be false). When the invoice has multiple payment methods (credit memo and invoice or multiple payments on the same invoice.) the line item amount gets duplicated and therefore overstates revenue.

Has anyone found a way to ensure line items don’t get duplicated when pulling the  Related transactions – Next — transaction payment type?