Multiple criterias in a Pivot filter

Hi
(Excel 2010)

In my pivottable I have a list of names.

Now I want to show only the rows with names including "ete" or "eve".
I can set up af filter for each, but how do I filter for both of them.

Furthermore I would like to show the rows with "Johnsson"
Is there a way to do it.

Something like :
Select *
from names
where (names like %ete% or names like %eve%) and names like %Johnsson%

Example:


NAMES

John Adams     (Not to to be shown)
Peter Grandjean (To be shown)
Eric Hansen (Not to be shown)
Evelyn Bond (To be shown)


Regards

Peter


0
pgrandjean (29)
5/19/2011 10:56:32 AM
excel 39879 articles. 2 followers. Follow

1 Replies
890 Views

Similar Articles

[PageSpeed] 33

hi Peter,

Set Pi = ActiveSheet.PivotTables(1).PivotFields(1)
On Error Resume Next
     For Each p In Pi.PivotItems
         If p.Visible = False Then p.Visible = True
     Next

     For Each p In Pi.PivotItems
         If p Like "*eve*" Or p Like "*ete*" Or p Like "*Johnsson*" Then p.Visible = True Else p.Visible = False
     Next



-- 
isabelle

0
isabelle
5/21/2011 4:09:49 AM
Reply:

Similar Artilces:

100% CPU by using filter in Excel
An employee tried to use filter in one special table and the PC did nee 100% CPU time and work more than 15 min. I checked it with other PC. The table is working and PC use only abou 50% CPU and need about 3 min to finish the job. I installed the last SP3 for office XP and it is not solved th problem. The employee has German OS and english office. Has anyone an idea? Please help -- languate ----------------------------------------------------------------------- languatec's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2654 View this thread: http://www.excelforum...

Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when I get the answer to this, but here goes... I have a workbook containing a worksheet that records weekly data. I have a named range ("Data") which I select then clear, via GoTo. Each week, I copy the latest week's worksheet and create a new worksheet for the new week. And each week, I select the range "Data" and clear it in the most recently created worksheet. the thing is, I always thought that Range names were unique across a workbook, and that you couldn't have the same Range N...

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee exactly the same funcitonality that you have on a Excel spread sheet either by converting it to a java applet or something else . Any hel would be much appreciate -- Message posted from http://www.ExcelForum.com ...

Pivot Table question #4
Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter nu...

Allen Browne Client Search Multiple Like Statements
Hi all, I need to have this code search multiple fields, but I keep getting "Expected end of statement" on the Me in the second to last line: If Not IsNull(Me.txtFilterMainName) Then 'strWhere = strWhere & "([MainName] Like ""*" & Me.txtFilterMainName & "*"") AND " strWhere = strWhere & "([Address1] Like ""*" & Me.txtFilterMainName & "*"") OR " & _ strWhere = strWhere & " ([StreetName] Like "" * " & Me.txtFilterM...

connecting to data access page with filter criteria
I have an access database that I connect to from a GIS application (ArcView) using VBscript. I need to port my GIS project to the free viewer (ArcReader) which does not support VBscript but does support hyperlinking to a URL based on a value supplied by an underlying record. In my current project I can send filter critera to open a particular database, form and record. Would it be possible to do the same using data access pages or would I need to create a separate page for each record I want linked? ...

Support of multiple users in Outlook?
Hi, Palm convert here with a question. In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. from my wife as a separate user. We both had palm devices and each maintained separate schedules on our devices and on the desktop. How do we do that in Outlook? Thanks, John "John" <ljohnwu@yahoo.com> wrote in message news:u2bnY$0DGHA.3528@TK2MSFTNGP12.phx.gbl... > Hi, > > Palm convert here with a question. > > In my Palm desktop I was able to separate my Notes, Calendar, Tasks, etc. > from my wife as a separate user. We both had palm ...

Assigning a criteria
I know am looking for the best way to accomplish the following: I often have situations where I need to interchange a criteria for the same report. For instance I have a report that I want to look up just projects that are active but I also need that same report to show all projects sometimes. What is the best way to assign an "active" or "all" status criteria into the report. Thanks. -- Message posted via http://www.accessmonster.com I typically build a WHERE CONDITION in code that checks user entered/selected values from controls and uses the criteri...

Multiple POP accounts in Outlook 2003
Hello, I have multiple POP accounts on my Outlook 2003 client. How do i setup Outlook to save mail from the multiple POP accounts to different folders so that it makes it easier for me to sort out my mail? TIA! //j you'll need to use rules... or use search folders configured for each account. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: ...

Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to include them after refreshing. Is there any way of setting the pivot table to include the entire database regardless of its continuously growing size? Right now, as I add a new row of data I must delete my old Pivot table and create a new one from scratch. Is this normal? You can use a dynamic range that grows/contracts with your data. Debra Dalgleish explains it all at: http://www.contextures.com/xlNames01.html#Dynamic David.c.h wrote: > > As I add new rows of data to my data base, my pivot table wil...

How to add multiple message senders to the blocked list automatica
-- Steve ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=5597e420-8dc2-4fc5-88df-130a7cc9fe32&dg=microsoft.public.outlook ...

Transfer combined investment transactions to multiple new accounts
In Money 2005 Deluxe, I have an investment account (with related cash account) with about two years of transactions. This mutual fund account (TRP) uses a separate account number for each mutual fund holding so that when I upgraded to Money 2005 and set up on line services for this account it downloaded each mutual fund investment as a new account. I can't merge all of these duplicate accounts in Money as it only allows you to merge one time so I then transfered (using copy) all my investment transaction from the combined existing account to each of the new individual investment ac...

Filter Date
Hi, I have a form which contains a listbox (holding the values Process Date and Quantity) and I have a textbox which displayed the current month. What I want to do is when I click on a command button (cmdMonthDown) and the textbox value changes from May to April I want the values in the listbox to be filtered so that only those values are disiplayed that were entered in April. If I'm not making sense please let me know otherwise your help would be appreciated. Thanks Reference the text box as a parameter in the list box's RowSourcee, e.g. if the text box shows the month name in fu...

Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content. The content from each of these 4 cells needs to be placed in a separate column to make a list that I can sort etc. Example: COLUMN A 1 01-04-425-001 2 Heatherridge Road #301 3 Harry Smith 4 H25 Condo Fairfax Place 5 01-05-356-041 6 McGrath Street # 56 7 Mary Jones 8 B45 Condo Lemon Circle . . . . . . and so on and so on every 4 cells. I have hundreds of 4 cell descriptions. I just can't do this one by one. Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I use it for e...

Merging to-do/task lists from multiple inbox folders
Hi- I am using Outlook 2007 and am trying to figure out how to merge to-do/task lists from multiple inbox folders. I have my inbox associated with my name, and then also a folder with my name that is associated with another inbox that is used by several people on one project. (When emails come into the latter folder, I sort the ones that I can deal with into the subfolder with my name.) For my personal inbox, I can flag emails and they will pop up in my to-do box, but when I flag things in my sub-folder they don't show up in my to-do box, and I can't figure out where t...

dropdown filter on Data Access Page
Hi, I have a data access page that is based on a query in my database. Currently the page brings up all data for today, and the page is formated into teams So it looks like this Today's date Team #1 entry #1 entry #2 Team #2 entry #1 Since this page can get long sometimes, I would like to add a dropdown menu at the top of the page, that allows them to filter their results by team. So once they make a selection they would only see the team selected. Today's date Team (only 1 listed) Entry #1 Entry #2 I've been trying to search on this, but jus...

How to send attachment to a filtered email list of people
Surely there must be a way to add an attachment to an email template? Do you have to use the email template when sending direct email through CRM? Whenever I do an advanced find and want to do an email to the group, the only choice is email templates that don't seem to have any attachment options. Someone please tell me they have a workaround for this. Much appreciated!! There may be a way, using workflow Create a new, manually invoked workflow rule that generates direct email. Don't use the template option. Then you can select an attachment. (See the unsupported "slug...

Passing Complex filter via URL
Hi Everyone, Ok, I'm baffle on this one and it may be that I’m trying to do it the “Crystal” way  I have many reports in which I pass parameters via the url. This works great. Now I need to pass complex statements that I’ll like to add/append to the Where command via URL. i.e. http://dummy.com/reportserver/misc/ReportServer/Pages/ReportViewer.aspx?rpAddToWhere=id>10 and level=urgent and table.field=(select field3 from x where sample=20)&/HelpDesk/HDTicketsDetail Any ideas on how I can achieve this? BTW, I'm using MSSQL 2005. Thanks in advance. BTW...

Filter records
Hi,I have a form that lists transactions. I would like to limit the listto show transactions from the previous 14 days.TIA Base the form on a query. Set the criteria for the date field to:>DateAdd("d",-14,Date())See Help for more information about the DateAdd function.<myxmaster@hotmail.com> wrote in message news:1173110246.288701.261950@t69g2000cwt.googlegroups.com...> Hi,> I have a form that lists transactions. I would like to limit the list> to show transactions from the previous 14 days.>> TIA> ...

Recommend a spam filter for Outlook2003 (i.e. anything better than Spambayes?)
Hi Can anyone recommend a spam filter for Outlook2003? I have tried SpayBayes for a couple of year... but now want something that works better! (I need something that works on my PC -i.e. within Outlook) The problems with SpamBayer are that: a) it seem to filter legit stuff from real people There is now way of saying "NEVER filter email from these people I have written to." b) I keep having to set up new mail accounts on my WindowsXP - and each time I set a new Outlook account up it 'forgets' everything it has learnt! c) there is no help from OTHER users. i.e. the commu...

Data display incomplete after creating Pivot Table
I have created pivot table from spreedsheet. One of the fields "additional comments" doesn't display fully in the pivot report. I have tried increasing column widths and row widths. I have also tried using Alt+enter as suggested in some of other discussion forum. Nothing is working so far. Any help appreciated. Thank you! Hi komal. I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 36 towards the top of my home page. It works OK for me. Check out the file. I hope that it helps in some way. If my comments have h...

How to add time from multiple cells & date Cells & machine type c
I'm trying to add up the amount of machinery downtime from a number of different cells but the thing is that I need to only have it added up by the date set in another cell (Which can have multiple cells of the same date) as well as the specific name of that machinery in another cell(which can also have multiples of the same machinery name). How can i get to just add up for that specific date, machine name, and time. Example: Date (Cell 1A thru 50A) Machinery Name(Cell 1B thru 50B) Downtime(Cell 1J thru 50J) Please help Thanks Example:Sheet1 Data Column A ...

opening multiple workbooks, opens in seperate program...
hi, when i open more than 1 woorkbook at the same time, it opens a secon icon at the bottom of my windows taskbar. but when i go to close one of the MSexcel programs it also wants t close the second one aswell.... previosly when i open multiple excel workbooks, it only showed on excel program as being open on the taskbar... can anyone give some insight into this? thanks : -- Message posted from http://www.ExcelForum.com p.s i am using excell 200 -- Message posted from http://www.ExcelForum.com Hi sokevin Tools>Options..View Change the Windows in taskbar option -- Regards R...

Pivot Table Calculated Formula If statement
Hi all, In a pivot table I am trying to add this formula: In the insert calculated field-->Formula field i type =IF('FIELD NAME'="STRING TO COMPARE", 1,0) Any Idea why this does not work? The calculated field operates on a sum of the field, and the sum of a text string is zero. The zero result won't equal the "String to compare", so the calculated field will return a zero. Perhaps you could do the calculation in the source data instead, and add that field to the pivot table. Dan McCollick wrote: > Hi all, > In a pivot table I am trying to a...