How to Display Column values to row in Straight table

[#1]

Hi I have data like

Team	Dept
Aab IT	Other
Aab IT	IT
Ssms	Normal
Abbms	None

here when I select  filter Team(Aab IT) in my straight table it is showing Other and IT in two rows, But I want to show it in a single row

like 'Other;IT'.

how can I show it

Please help me.

[awhitfield · Accepted solution]

I presume your expression I currently "dept", in which case, change it to Concat(Dept,';')

Andy

[sunny_talwar]

Use Team as dimension and Concat(Dept, ';') as expression