Split Values in Pivot or Straight Table

podge2019 — Fri, 15 Nov 2024 23:11:35 GMT

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

Re: Split Values in Pivot or Straight Table

edwin — Sat, 06 Feb 2021 00:00:27 GMT

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