Home > Pivot Table > Pivot Table Cannot Show Or Hide Detail For This Selection

Pivot Table Cannot Show Or Hide Detail For This Selection

Contents

To hide to a level of detail beyond the next level, click Collapse To "". Just click the sign up button to choose a username and then you can ask your own questions on the forum. Select a Product... To protect others from seeing this data, you can turn it off. this contact form

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Any other feedback? Is it possible to add a calculated field in a row under the "subtotal" row. Any other feedback? http://www.helpinfo.com/index.jsp?k2dockey=1021040136932906907&formwassubmitted=true

Excel Pivot Table Collapse All

if so any help would be greatly appreciated Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? What do you want to do? If you're having a computer problem, ask on our forum for advice.

Is this possible ? simondgear posted Nov 9, 2016 at 1:15 PM Web of Trust browser add-on pulled after privacy lapse V_R posted Nov 9, 2016 at 11:58 AM WCG Stats Wednesday 09 November 2016 Dialog text: Cannot show or hide detail for this selection. Pivot Table Show Details In Same Sheet Right-click the pivot item, then click Expand/Collapse In this example, I right-clicked on Boston, which is an item in the City field.

Right-click the selection, point to Filter, and then click Hide Selected Items or Keep Only Selected Items. Pivot Table Expand Only One Row Similar Threads Distinct Count functionality in Pivot Table (not OLAP!) Guest, Jan 24, 2004, in forum: Microsoft Excel Worksheet Functions Replies: 1 Views: 3,630 Peo Sjoblom Jan 25, 2004 Using A Display or hide items in a PivotTable report Display or hide levels in a PivotTable or PivotChart report Display or hide items in a PivotTable report You can hide specific items http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/pivottable-external-data-cannot-show-or-hide/2e089bf9-8550-e011-8dfc-68b599b31bf5 Password Register Forum Help Today's Posts Search Search Forums Show Threads Show Posts Advanced Search Go to Page...

For example, starting at a country/region level, you can expand to a city level which expands both the state/province and city level. Excel Expand Collapse Rows You can't change collapse Bars in one Region only. Please try the request again. Guest Hi, has anyone had any experience with using an OLAP data source for a pivot table and tried to use the Show and Hide detail function in Excel?

Pivot Table Expand Only One Row

Select on of the Expand/Collapse options: To show details below the selected level, click Expand To [Field Name]. see it here The file is zipped, and in xlsx format, with no macros. Excel Pivot Table Collapse All Share Share this post on Digg Del.icio.us Technorati Twitter Best regards, Allan Chara http://www.mrspreadsheets.com Reply With Quote Aug 14th, 2012,10:57 AM #3 csivell New Member Join Date Aug 2012 Posts 45 How To Remove Expand Collapse In Excel Pivot On the Options or Analyze tab (depending on the Excel version you are using) on the ribbon, in the PivotTable group, click Options.

Top of Page Display or hide levels in a PivotTable or PivotChart report You can also hide levels that you don't want to view in your report. weblink FaultWire View Public Profile Find More Posts by FaultWire « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid It takes just 2 minutes to sign up (and it's free!). Show or hide details for a value field in a PivotTable By default, the option to display details for a value field in a PivotTable is turned on. Pivot Table Expand All Levels

To see the details for all items in a field, click Expand Entire Field. Expand or collapse levels in a PivotTable In a PivotTable, do one of the following: Click the expand or collapse button next to the item that you want to expand or For example, you may want to hide a state/province level because the country/region that you are analyzing has no data for states or provinces, and you want to make the report http://amigasuperbit.com/pivot-table/pivot-table-cannot-group-selection.html I try to double click on it and it comes up with this message "Cannot Show or hide detail for this selection".

To see a level of detail beyond the next level, click Expand To "". Pivot Table Show Details Multiple Cells These are the small + / - signs at the left side of a pivot item heading. Expand or Collapse Entire Pivot Table Unfortunately, there is no command that will expand or collapse the entire pivot table.

Send No thanks Thank you for your feedback! × English (United States)‎ Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Sign in Search

Right-click on one of the headings in the outermost field, click Expand/Collapse, then click click Expand To or Collapse To, for the lowest level field. In Excel 2010: On the Options tab, in the Show group, click +/- Buttons to show or hide the expand and collapse buttons. VPDan, May 1, 2008, in forum: Microsoft Excel Worksheet Functions Replies: 0 Views: 412 VPDan May 1, 2008 Pivot Tables: Don't show data for detail, but still show subtotals Lynndyhop, Feb Excel Expand Collapse Columns Double-click the item that you want to expand or collapse.

Generated Thu, 10 Nov 2016 11:37:04 GMT by s_hp90 (squid/3.5.20) Sign in Search Microsoft Search Products Templates Support Products Templates Support Support Apps Access Excel OneDrive OneNote Outlook PowerPoint SharePoint Stay logged in Welcome to PC Review! To see the details for all items in a field, click Expand Entire Field. his comment is here We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

Show or hide the expand and collapse buttons in a PivotTable The expand and collapse buttons are displayed by default, but you may have hidden them (for example, when you don't The Expand and Collapse commands do not affect items that have been filtered Video: Expand and Collapse Pivot Fields Display the Expand/Collapse Buttons Expand or Collapse a Specific Pivot Item Expand Right-click the item, click Expand/Collapse, and then do one of the following: To see the details for the current item, click Expand. In this example, clicking on Collapse to "Region" will collapse the East region to the Region level.

Your browser can't show this frame.