Remove totals from a pivot table

[maffonso]

Hi guys,
I have created a VB code through 'Record a new Macro'. This code
builds a pivot table.The problem is that the table created has totals
but Id like a pivot table without totals. How can i remove those
totals
through VBA code?
Thank you all

[Tom van Stiphout]

Re: Remove totals from a pivot table

On Fri, 5 Sep 2008 17:31:27 -0700 (PDT), maffonso
<mmaffonso@gmai l.comwrote:

Can you post what you have so far?

-Tom.
Microsoft Access MVP

>Hi guys,
I have created a VB code through 'Record a new Macro'. This code
>builds a pivot table.The problem is that the table created has totals
>but Id like a pivot table without totals. How can i remove those
>totals
>through VBA code?
>Thank you all