Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GGG
 
Posts: n/a
Default how do i only see subtotals in a pivot and hide the detail




  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default how do i only see subtotals in a pivot and hide the detail

Hi

Right-click on returned table, ans select Table Options
Uncheck both Grand Totals for Rows and Grand Totals for Columns


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"GGG" wrote in message
...





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
Using Pivot Charts, how to hide field values in second level filters? elrao Excel Discussion (Misc queries) 1 June 17th 05 10:22 AM
Eliminating Pivot Table Subtotals [email protected] Excel Discussion (Misc queries) 4 June 3rd 05 01:39 PM
Pivot table - hide detail for column kbear Excel Discussion (Misc queries) 0 March 22nd 05 07:11 PM
Hide part of Pivot Table Ben Excel Worksheet Functions 1 March 8th 05 07:40 PM
pivot table - hide details but show subtotal for calculated field tenneym Excel Discussion (Misc queries) 1 February 9th 05 03:07 AM


All times are GMT +1. The time now is 07:13 PM.

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"