1 Reply Latest reply: Sep 19, 2018 1:41 AM by Manoj Kumar M R RSS

    concatenation in calculated dimension

    Manoj Kumar M R

      Hi Guys,

       

      I have a table which resembles like below Emp table. I need to concatenate Dept column with respect to other columns (as shown in expected result) and also country selection in list box should not effect this straight table.  Please let me know how can I achieve this.

       

      Emp:  

      Emp IdCountryDept
      1USSales
      1USIT
      2INSales
      2INHR

       

       

      Expected result:  

      Emp IdCountryDept
      1USSales, IT
      2INSales, HR

       

       

      I tried to use Concat function (concat(total <Id> Dept,', ')) and added one more dummy measure (sum({<Country=>}1)) to exclude country selection, but it is not working, as Concat can only be used inside measure.