Show/ Hide complete column with 'Null' or 'no Values' in straight Table

[santho_ak]

Show/ Hide complete column with 'Null' or 'no Values' in straight Table. 

Actual :

I am able to hide the 'Salary' column using the condition Count(Salary)>0 or Sum(Salary)>0. (Not sure if it is right but it works)

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

 Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

Required:

[Anil_Babu_Samineni]

Check these

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

- Check "Supress When value is null" is one option

- May be write calculated condition : If(Len([Request Type])>0, [Request Type])

 Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

- Enable Calculate condition for Coulmn.If like... If(IsNull([Request Category]), 0,1)

[santho_ak]

Thanks @Anil_Babu_Samineni . For Que 2, its not working.

[Anil_Babu_Samineni]

My case it is working, check once