Column value in Excel

[LornaLouw]

hi everyone,

Please find attached.

the column names, e.g. Business Banking - the Volume value already has been calculated in the source that this pivot uses. So...for the total at the bottom of Business Banking, I ONLY want to see 6648 for the Volume total...not
990552 (which is 6648 * 149)

I know by nature, the pivot wants to add up everything, but for this one, I only need the Volume value

Thank you