How to display more than one value in a pivot table expression?

[nishanthi_8]

Hi I have a data like this:

ID  SECTION  VALUES

1    Products     aaaa

1    Products     bbbb

2    Products     cccc

3    Products     dddd

3    Products     eeee

3    Products      ffff

where i use pivot table to display it is not showing more than one value in the table.. Can anyone help please?

[kaushiknsolanki]

Hi,

I couldnt understand your requirement, can you please elaborate using some example.

Let us know what output you are looking for.

Regards,

Kaushik Solanki

[sunny_talwar]

May be use Concat(VALUES, ', ') as your expression