How to enable conditional value for a record to hide in a Column field

[Anonymous]

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.

[#2]

if(Department Type = 'Sales', NULL(), Department Type)

Try this in dimension...

[alexandros17]

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

[awhitfield]

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

[davdiste]

Hi,

resolved with a trick.

In the table I've defined an expression that is always true, than in the presentation tab I've hide it.

Now Work!!!

[buzzy996]

PFA,

[davdiste]

?

[buzzy996]

see in attached file.

[Anonymous]

Andy, It is done.

Thanks for your response and time.

[awhitfield]

Excellent!

Andy