how can I stop sub total rows appearing in pivot tables in excel

[Guest]

I am working in excel and I need to prevent sub total rows appearing in my
pivot tables. Does any know if this is possible and if so how?
Also, I am working in Access and I need to be able to have multiple columns
headers (grouped) similar to what you can do in Excel, any ideas?
Thanks for your help.
Lee

 

[Dave Peterson]

If you rightclick on the button like header in your pivottable, you can select
"field settings".

there's a "none" option for subtotals.

If you don't get an answer for your access question, you may want to try an
Access newsgroup.

 

[Debra Dalgleish]

And to hide the subtotals programmatically, there's sample code here:

http://www.contextures.com/xlPivot03.html#Subtotals

In Access, if you're trying to duplicate Excel's Group and Outline
feature, there's nothing similar that I'm aware of. In a table, you can
manually hide or show columns. In a form, you could probably write some
code to hide or show columns.

You can also create a pivot table in Access, and group items there.