Split SumTotal according to underlying criteria (Std Pivot)

As the attached example will hopefully illustrate, I need to split a SumTotal by criteria used in the table.

I have run out of ideas after extensive reading and testing :-)

Torers
Excel Home 2013-8.1

Populate J16 with the formula:

Please Login or Register  to view this content.

then copy across and down.

Let me know if you have any questions.

Brushed up on GETPIVOTDATA