Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2014, 09:28 PM
macropod's Avatar
macropod macropod is offline Multiple Label Criteria - Pivot Table Windows 7 64bit Multiple Label Criteria - Pivot Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


If you call L1 'Row Suffixes' and use the following formula in L2 and copy down, you can then filter on that column:
=RIGHT(A2,6-FIND("-",RIGHT(A2,6)))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-26-2014, 11:01 PM
philipq philipq is offline Multiple Label Criteria - Pivot Table Windows 7 64bit Multiple Label Criteria - Pivot Table Office 2010 64bit
Novice
Multiple Label Criteria - Pivot Table
 
Join Date: Oct 2014
Posts: 2
philipq is on a distinguished road
Default

Hi Macropod,

Thank you for your response.

Yes, you are correct. However, is multiple label or value filter (all in one shot) possible using a pivot? From my findings using the pivot interface it is not. I was thinking maybe the pivottable object might allow for it via programming.

Best Regards,
Philip

Last edited by philipq; 10-26-2014 at 11:02 PM. Reason: missed a statement
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Label Criteria - Pivot Table Copy Multiple Rows to new workbook when multiple criteria is met. flds Excel Programming 5 09-30-2014 09:58 AM
VBA Pivot Table CubeField Enable multiple items Wries Excel Programming 0 03-13-2014 09:56 AM
Pivot table auto print. For multiple values. Nicholaspoe Excel 0 10-08-2013 09:08 PM
Ranking with multiple criteria angie.chang Excel 0 08-14-2012 04:49 PM
Multiple Label Criteria - Pivot Table Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 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