Remove Totals on Pivot Table

[Brandy]

Hello,

How do I remove the totals from my Pivot Table? I only want to keep the individual count from the particular fields.

Thank you.

Sean

[dominicb]

Good evening Brandy

How do I remove the totals from my Pivot Table? I only want to keep the individual count from the particular fields.

Right click on your pivot table and select PivotTable Options. From the dialog box that then opens untick the boxes marked Grand Totals for Columns and Grand Totals for Rows.

HTH

DominicB

[DonkeyOte]

posted in other EF.com forum:

http://www.excelforum.com/excel-gene...vot-table.html

[royUK]

Brandy, stick to the original posting. Do not duplicate, if ou feel a different forum is more appropriate contact a Mod to move it.