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) .