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

[PFDave]

In the values part of your pivot table toolbox on right hand side, right click on Volume and set as Average, or Max or Min to achieve what you are looking for.

[LornaLouw]

Thank you so much, but I get a division by Zero error on some lines

sorry - I just use Min or Max - it works

thanks again