Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
IN dimension write:
If([Department Type] = 'Sales' or [Department Type] = 'HR', null(), [Department Type])
and check the checkbox "Suppress values when null"