Click here to Skip to main content
15,938,328 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an Pivot table in an Excel Sheet where i want to put an custom filter on the label Worktype. The Worktype can have only 5 values i.e. Non Production, REX, QA, RES, BP. The filter should be like this that: IF(WorkType Contain only "Non Production) then Show "Non Production" in WorkType, else Hide "Non Production" in WorkType and show remaining WorkType (REX,QA,RES,BP) .
Posted
Comments
Herman<T>.Instance 22-Feb-12 8:10am    
which excel version?
Dharmenrda Kumar Singh 22-Feb-12 23:51pm    
2007
Bassam Abdul-Baki 19-Apr-12 8:59am    
Some sample data would make it easier to understand the problem.
Sunny_Kumar_ 19-May-12 6:37am    
post a sample data so that we can get a picture of your actual need.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900