Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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,943
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

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
__________________
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-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
  #3  
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
Reply

Tags
extracting data, pivot table, show details



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 01:37 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