Hello,
How do I remove the totals and grand total from the pivot table?
I only want to show the individual count.
Thank you.
Brandy
Hello,
How do I remove the totals and grand total from the pivot table?
I only want to show the individual count.
Thank you.
Brandy
Last edited by Brandy; 01-16-2009 at 02:38 PM.
A couple of ways -- easiest probably to right click on a Total entry and choose Hide.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Posted in other EF.com forum, see:
http://www.excelforum.com/excel-work...vot-table.html
Brandy, do not duplicate your questions in multiple Forums
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks