Payroll journal report: By Employee, all PAYCODES, nominal codes, split/grouped by Cost Centre

1. I have tried this with a custom report but all you get is the primary Cost Centre.

2. The other payroll journals roll up pay codes into summary codes like NET PAY, and you cannot know for sure which PAY CODES are being summed up, and you cannot define a nominal code mapping for NET PAY.

We want to be able to see how much of each employee's pay is going to each PAY CODE (within nominal account mapping) on their respective pay slips, by Cost Centre split.

Flat file, so we can put it into an Excel pivot table. Happy to use Power Query to rearrange the table layout to be pivot table friendly - the main thing is easy access to the source data.