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
Bookmarks