value showing based on some other column value

[#1]

Hi All,

I have the data like below in Pivot table.

Column A     Column B                       Column c

     Name                XXX                          India        

                              YYY                          Singapore     

                              ZZZ                           China  

       Accout            Savings                     Hongkong

                              Current                      Malaisai

                              Demat                       US

I want to put Column B as blank like - or spcae when Column A have Account and Column C should be as usual.

Thanks,

Ravi Teja.

[#2]

Just create a ColumnB as calculated dimension like below.

If(ColumnA='Account','-',ColumnB)

Hope helps U.

Regards,

Kabilan K.

[#3]

in calculated dimension write this code

if(columnA='Account','-',ColumnB)

********************************************

or in script write this code

LOAD *,

if([Column A]='Accout','-',[Column B]) as [Column B _new];

LOAD * INLINE [

    Column A, Column B, Column c

    Name, XXX, India

    Name, YYY, Singapore

    Name, ZZZ, China

    Accout, Savings, Hongkong

    Accout, Current, Malaisai

    Accout, Demat, US

];

see attachement