Hi!

I create pivot table using VBA and there are two row fields and they
are Site and AU as folllows

..PivotFields("SITE").Orientation = xlRowField
..PivotFields("AU").Orientation = xlRowField

When the pivot table is created, it will display the row total for
Site. We donot want the row total to be shown. Is there any way that I
can remove the row total?

Also, can we remove the Column and Row Grant totals?

How to do this use VBA code?

Thanks,

Aijun.


--
Ai_Jun_Zhang
------------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474
View this thread: http://www.excelforum.com/showthread...hreadid=488855