Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I presume your expression I currently "dept", in which case, change it to Concat(Dept,';')
Andy
I presume your expression I currently "dept", in which case, change it to Concat(Dept,';')
Andy
Use Team as dimension and Concat(Dept, ';') as expression