14 Replies Latest reply: Sep 21, 2018 9:47 AM by Bernd Jägle RSS

    Concatenating Multiple Values of a Field

    Linda Pembroke

      Hi,

      I am wanting to concatenate multiple 'MRP D/C Dates' into one cell in order to only have 1 row per member in my pivot table. In my example there are only 2 dates, but there can be more than that. I have tried creating variables and combining those but that gives me errors in my calculated dimension. For instance, in the below example I would like to see '11/28/2016, 3/29/3016' in one row rather than it creating 2.

       

       

      Any help is appreciated!