Pivot Table shows Grand total

[GN0001]

I don't need this field. It keeps showing on my pivot table. How to get rid of that?

Thanks,

Guity

 

[Hui]

Right Click on It, Remove Grand Total

 

[GN0001]

Thank you for the answer, I was doing pivot tables and I didn't search enough and send this to you. Thank you for the answer. The sumproduct you have sent me has helped in a lot of situations.


Guity