#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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
__________________
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 |
#3
|
|||
|
|||
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! |
#4
|
||||
|
||||
Please post a sample sheet. Thanks
__________________
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 |
#5
|
|||
|
|||
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,
|
#6
|
||||
|
||||
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
__________________
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 |
#7
|
|||
|
|||
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
|
#8
|
|||
|
|||
Extracting data
Any response from my latest question? Thank you.
|
#9
|
||||
|
||||
My XL version is 2010 but perhaps this works in 2016?
https://support.office.com/en-gb/art...7-629bf6f7ee0b
__________________
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 |
#10
|
|||
|
|||
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 |
#11
|
||||
|
||||
Perhaps like this?
__________________
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 |
#12
|
|||
|
|||
That would be nice but I have 12,000 unique businesses so it would be tough to add that for each business.
|
#13
|
||||
|
||||
What do you mean? Is there no Subtotal tool under Data in 2016?
__________________
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 |
#14
|
|||
|
|||
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 |
#15
|
||||
|
||||
__________________
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 |
Tags |
extracting data, pivot table, show details |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Show Items with no data | DeborahBartlett | Excel | 1 | 01-24-2012 01:10 AM |