Hiding multiple records in a Column

[Anonymous]

Hello,

Below data is in Pivot table.

Requirement: Related data should not display when "Department Type" is "Sales" and "HR".

Input Data:

"Date" "Category" "Department Type" "Employee"

1      IT                   Software                A

2    NonIT               Sales                     B

3    NonIT               Sales                     C

4     IT                    Software                 D

5     IT                    Software                 E

6   IT-Related         HR                         F

Required Data after suppression of null values.

"Date" "Category" "Department Type" "Employee"

1      IT                   Software                 A

4     IT                    Software                 D

5     IT                    Software                 E

[alexandros17]

IN dimension write:

If([Department Type] = 'Sales' or [Department Type] = 'HR', null(), [Department Type])

and check the checkbox "Suppress values when null"