Custom report not creating invoice properly

Hi all,

I’ve created a custom report with the breakdown that I want. When I click the 3 dots and click create invoice, it doesn’t create the invoice properly - it line items each date, instead of each week. I’ve tried a few different ways; as a pivot table, etc. Screenshots attached.

Is there any way to fix this?

Thanks!