Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one small doubt. How can I set a condition for a field in Column.
I have below data in a Straight table and I want to hide or set to null the records "Sales" in column "Department Type".
I tried functions Match, GetSelecFields and Set Analysis but unable to solve this issue.
Can anyone help me?
"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
I do not want to see Sales in Department Type column and result should be either 0 or Null.
Thanks,
Shiva.
if(Department Type = 'Sales', NULL(), Department Type)
Try this in dimension...
I think that Department Type is a dimension so:
If you need to hide the Whole row containing "Sales" then write (as dimension)
If([Department Type]='Sales', Null(), [Department Type])
Check the box "Suppress when value is null"
Let me know
Hi Shiva,
replace the Department Type Dimension with a calculates one:
=If([Department Type]='Sales',NULL(),[Department Type]) The output will be:
HTH - Regards Andy
PFA,
?
see in attached file.
Andy, It is done.
Thanks for your response and time.
Excellent!
Andy