Pivot table - hide columns

[#1]

Hi All,

How to hide columns in pivot table

I have wave1 and wave2 columns and i have to hide wave1 columns other than total column at Column level.

Please help.

[#2]

Hi,

I am facing issue with null. below is my expression.

if ( sum(Alt(Value,0)) = 1 ,    Dual('Yes',1) ,  if ( sum(Alt(Value,0)) = 0 , Dual('No',0) ,  sum(Alt(Value,0))))

I need to check if the value is null then i have to display as 'N/A'.

Please help.

Thanks.