Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2016, 01:35 PM
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


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.

Last edited by jhato160; 07-28-2016 at 07:52 AM. Reason: See edit
Reply With Quote
  #2  
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
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
Reply With Quote
  #3  
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
  #4  
Old 07-28-2016, 09:43 AM
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Please post a sample sheet. Thanks
Reply With Quote
  #5  
Old 07-29-2016, 07:30 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 Example sheet attached

Please see attached sheet. The pivot table allows me to breakdown the number of units per property owner. I want to extract all owners with more than 2 units. I am highlighting the numbers in B4-B7, right clicking, selecting "Show details," and it only extracts the selection from B4 into the new extracted data sheet. How can I extract the data for multiple selections? Thanks,
Attached Files
File Type: xlsx Help Example.xlsx (17.7 KB, 4 views)
Reply With Quote
  #6  
Old 07-29-2016, 08:48 AM
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Click the Row labels drop down
Select "Value " filters" then " Greater then"
Enter 2 in the empty textbox
OK

Double clicking on any result in the Count column will extract the details
Reply With Quote
  #7  
Old 07-29-2016, 10:56 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 Data Extraction

That makes sense, however, I don't want to create an individual sheet for every result in the count column. I want to extract all of the date from the 4 remaining results onto one worksheet at the same time. Does that make sense? If you can't do this from the pivot, is there another way? Thanks
Reply With Quote
  #8  
Old 07-31-2016, 12:47 PM
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 Extracting data

Any response from my latest question? Thank you.
Reply With Quote
  #9  
Old 07-31-2016, 11:26 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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

My XL version is 2010 but perhaps this works in 2016?
https://support.office.com/en-gb/art...7-629bf6f7ee0b
Reply With Quote
  #10  
Old 08-01-2016, 05:13 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 Extracting data

My OLAP tools are greyed out so I can't do drill in or out.

I have a list of over 30,000 companies with property. I want to extract data based on the number of properties each company has. Seems like that would be easy but the data is numbered with "1's" because of the way the data is collected so the only way I know to sort the data and sum this amount of data is in a pivot table.

Any thoughts on that?

Thanks,

Jake
Reply With Quote
  #11  
Old 08-01-2016, 07:47 AM
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Perhaps like this?
Attached Files
File Type: xlsx Copy of Help Example.xlsx (18.8 KB, 6 views)
Reply With Quote
  #12  
Old 08-01-2016, 07:59 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

That would be nice but I have 12,000 unique businesses so it would be tough to add that for each business.
Reply With Quote
  #13  
Old 08-01-2016, 08:24 AM
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

What do you mean? Is there no Subtotal tool under Data in 2016?
Reply With Quote
  #14  
Old 08-01-2016, 10:47 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

I am fairly new to pivots so I am not sure what the subtotal will do. I went through and tried to subtotal but nothing happened. I set subtotal to automatic but nothing happened.

So, if I am trying to extract all of the data from the top 250 items from the pivot table, the subtotal is how I achieve that?

Thanks,

Jake
Reply With Quote
  #15  
Old 08-01-2016, 11:24 AM
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,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Try http://www.dummies.com/how-to/conten...xcel-2013.html
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 - Senior Forums

All times are GMT -7. The time now is 02:02 PM.


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