Re: how can I stop sub total rows appearing in pivot tables in excel
From: Dave Peterson (ec35720_at_msn.com)
Date: 09/16/04
- Next message: Dave Peterson: "Re: auto save path"
- Previous message: Dave Peterson: "Re: Show/Hide Pivot Fields"
- In reply to: Lee: "how can I stop sub total rows appearing in pivot tables in excel"
- Next in thread: Debra Dalgleish: "Re: how can I stop sub total rows appearing in pivot tables in excel"
- Reply: Debra Dalgleish: "Re: how can I stop sub total rows appearing in pivot tables in excel"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Sep 2004 16:56:01 -0500
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.
Lee wrote:
>
> 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 ec35720@msn.com
- Next message: Dave Peterson: "Re: auto save path"
- Previous message: Dave Peterson: "Re: Show/Hide Pivot Fields"
- In reply to: Lee: "how can I stop sub total rows appearing in pivot tables in excel"
- Next in thread: Debra Dalgleish: "Re: how can I stop sub total rows appearing in pivot tables in excel"
- Reply: Debra Dalgleish: "Re: how can I stop sub total rows appearing in pivot tables in excel"
- Messages sorted by: [ date ] [ thread ]
