Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2016, 11:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Pivot Table: Show Data For Multiple Items Windows 7 64bit Pivot Table: Show Data For Multiple Items Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default


Please post your question in words on the forum and post a sample sheet showing data and expected results.
External links are potentially unsafe and cannot always be opened by members, depriving you of answers.
Thank you
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 07-28-2016, 07:50 AM
jhato160 jhato160 is offline Pivot Table: Show Data For Multiple Items Windows 10 Pivot Table: Show Data For Multiple Items Office 2016
Novice
Pivot Table: Show Data For Multiple Items
 
Join Date: Jun 2016
Posts: 13
jhato160 is on a distinguished road
Default Pivot Table - Show Data For Multiple Items

Ok, sorry. Thought it would be easier.

I created a pivot table from a master data list and have a bunch of businesses with all of the data related to that business. The data in the pivot table is sorted by business name and number of stores. I want to be choose all the stores with 10 or more locations and be able to "show details" (where it opens another worksheet with all the data from the master list for the selected items). I have been highlighting multiple selections and clicking "show details" but it has only been extracting the first highlighted business.


Please advise. Thank you!
Reply With Quote
Reply

Tags
extracting data, pivot table, show details

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table: Show Data For Multiple Items How to vba pivot table to deselect items but sometimes one item may not be there mbesspiata3 Excel Programming 1 04-22-2016 07:32 AM
Include and Exclude items through vba in pivot table mbesspiata Excel Programming 0 02-22-2016 12:30 PM
Selecting/deselecting items in pivot table mbesspiata Excel 0 07-22-2014 08:15 AM
VBA Pivot Table CubeField Enable multiple items Wries Excel Programming 0 03-13-2014 09:56 AM
Pivot Table: Show Data For Multiple Items Show Items with no data DeborahBartlett Excel 1 01-24-2012 01:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft