Click here to Skip to main content
14,601,204 members
Rate this:
Please Sign up or sign in to vote.
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
digimanus 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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100