How to Split a row item in 2 parts?

[nehapathak]

Hi this is my code i want to split Vikram Nair'  in 2 parts so that when we expand it it shows further segregation as BT and  Europe(ENT + Comms(NON BT).

Text(

     if("SBU Head Name"='AM'  or "SBU Head Name"='KN' or "SBU Head Name"='SB'

     or "SBU Head Name"='MC or "SBU Head Name"='DT' or "SBU Head Name"='WC'

     or "SBU Head Name"='RA'  or "SBU Head Name"='CTL','Sbu',

     if("SBU Head Name"='VA' or "SBU Head Name"='VK','VBU',

     if("SBU Head Name"='-','Others',

    If("SBU Head Name"='VN', If((ApplyMap('map_btjuly',"Emp ID") )='C,R' ,'BT','Europe')))

    ))) as sbuhead,

I want expansion of VN

Can somebody help?

[arvind_patil]

HI Neha,

You r giving live data from Tech Mahindra. Try to give dummy  data.

Thanks,

Arvind Patil