Row Totals in a pivot table. Total column question.

I have a pivot has three value columns. Total volume represents the sum of all products shipped. No Subs represents how many of these have been substituted and "-%" is the percentage substitutions.

The issue I have is with the row totals. Total Vol and Total No Subs are fine but the -% column is the sum of all the substitutions rather than the % of substitutions made overall.

I think I am making a fundamental mistake but I can't fix it with my feeble excel skills. Any help would be appreciated.

Many Thanks

Argh.png


Help.xlsx