8 Replies Latest reply: May 9, 2014 4:08 AM by anbu cheliyan RSS

    Get all field values

    Eva Stein

      Hi,

       

      I need to concatenate all field values inside a straight table, disregarding the selections made in this field.

       

      Example:

       

      Category     ProductNr

      -------------     ---------------

      A               1

      A               2

      B               1

      B               4

      C               1

      C               5

      C               6

      D               7

      D               8

       

      A selection is made in field ProductNr, Value 1.

      The straight table with dimension Category and concatenation over ProductNr. displays:

       

      A               1

      B               1

      C               1

       

      But what I need is every value given for the selected ProductNr. and the associated Category:

       

      A               1,2

      B               1,4

      C               1,5,6

       

      Are there any possibilities via set analysis? I have tried some, but nothing worked...

       

      Thanks in advance!