13 Replies Latest reply: Apr 27, 2017 8:43 AM by Linda Pembroke 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!