Exposing multiple values in a pivot table cell

[Anonymous]

Hi,

as the subject, I need to show more than one values in a cell of a pivot table, but I'm not able to do it.

Pls, have a look at the attachment qv sheet: for the A customer I have two orders (3, 4) in the same day (01/01/2017), but I can't see them in the pivot table.

can someone help me?, please?

Thanks.

N.

[MK_QSL · Accepted solution]

Becuase you are not using any aggregation here..

Use this as an expression

Concat(DISTINCT OrderNo, ', ' )

[Anonymous]

Great!

Thank you so much!

N.