Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal line

In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default In Excel 2007 PivotTables, what happened to "hiding" subtotalline

You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:
In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal

Thanks for the answer. It does, indeed, address the question that I asked.

Here's the additional functionality that I need: In Excel 2003, the
pivottable fields were displayed on a SINGLE row after you removed all field
subtotals. For the life of me, I can't figure out how to get Excel 2007
pivottables to display just ONE row after I remove all field subtotals.

Thanks,
--Au

"Debra Dalgleish" wrote:

You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:
In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal

Oh, now I have found it.

PivotTable Tools
Design Tab
Report Layout
Show in Tabular Form

That does the trick. Thanks for sending me to the Design Tab. That was the
missing link.

--Au

"Aurelio" wrote:

Thanks for the answer. It does, indeed, address the question that I asked.

Here's the additional functionality that I need: In Excel 2003, the
pivottable fields were displayed on a SINGLE row after you removed all field
subtotals. For the life of me, I can't figure out how to get Excel 2007
pivottables to display just ONE row after I remove all field subtotals.

Thanks,
--Au

"Debra Dalgleish" wrote:

You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:
In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal

I'm not sure if this is what you want, but --

On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Report Layout
Choose Show in Tabular Form


Aurelio wrote:
Thanks for the answer. It does, indeed, address the question that I asked.

Here's the additional functionality that I need: In Excel 2003, the
pivottable fields were displayed on a SINGLE row after you removed all field
subtotals. For the life of me, I can't figure out how to get Excel 2007
pivottables to display just ONE row after I remove all field subtotals.

Thanks,
--Au

"Debra Dalgleish" wrote:


You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:

In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal

That does it, yes. Thanks very much for your time! --Au

"Debra Dalgleish" wrote:

I'm not sure if this is what you want, but --

On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Report Layout
Choose Show in Tabular Form


Aurelio wrote:
Thanks for the answer. It does, indeed, address the question that I asked.

Here's the additional functionality that I need: In Excel 2003, the
pivottable fields were displayed on a SINGLE row after you removed all field
subtotals. For the life of me, I can't figure out how to get Excel 2007
pivottables to display just ONE row after I remove all field subtotals.

Thanks,
--Au

"Debra Dalgleish" wrote:


You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:

In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default In Excel 2007 PivotTables, what happened to "hiding" subtotal

You're welcome! Thanks for letting me know that it helped.

Aurelio wrote:
That does it, yes. Thanks very much for your time! --Au

"Debra Dalgleish" wrote:


I'm not sure if this is what you want, but --

On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Report Layout
Choose Show in Tabular Form


Aurelio wrote:

Thanks for the answer. It does, indeed, address the question that I asked.

Here's the additional functionality that I need: In Excel 2003, the
pivottable fields were displayed on a SINGLE row after you removed all field
subtotals. For the life of me, I can't figure out how to get Excel 2007
pivottables to display just ONE row after I remove all field subtotals.

Thanks,
--Au

"Debra Dalgleish" wrote:



You can right-click on a subtotal, and remove the check mark from
Subtotal<fieldname

Or, to hide all the subtotals:
On the Ribbon, in the PivotTable Tools tab, click the Design tab
In the Layout group, click on Subtotals
Choose Do Not Show Subtotals

Aurelio wrote:


In Excel 2003, you right-click a subtotal line that you don't want to have
displayed. You then click "Hide." Poof. All subtotals for that row heading
disappear from the whole pivot table.

Where has this feature gone in Excel 2007? I can't find it anywhere.
Thanks. --Au


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"edit query" button in Excel 2007 has been hidden Andre Ranieri Excel Worksheet Functions 2 May 2nd 23 04:44 AM
How do display a "+" or "-" sign when hiding columns? DTI Tustin Setting up and Configuration of Excel 1 July 13th 06 02:21 PM
What has happened to "Save As" in Excel 2003 Neil Excel Worksheet Functions 9 April 5th 06 07:10 AM
How do you get "Show Page" functionality in MSExcel PivotTables Engineering Accountant Excel Discussion (Misc queries) 1 February 27th 06 10:30 PM
Excel subtotals should subtotal "blanks" separately. id4post20061 Excel Worksheet Functions 0 February 4th 06 01:46 PM


All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"