Split Values in Pivot or Straight Table

[podge2019]

Hello,

Looking for help as to how I could split the below values.

In the table below I need to split it to have 4 splits. i.e.

For Product WH3 it needs to be split by Transaction Type e.g. Manual or Premium Collection. This is two subtotals.

For Product Y6Z it needs to be split by Commission Type e.g. PSC or COM. This is the other two subtotals.

There will be subtotals based on this split, however, if I just get it split then I can work on the subtotals separately.

Any assistance would be appreciated:

Thanks,

Padraig

[edwin]

are there rules to identify which product will be split which way?  surely you dont have just 2 products.