Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Becuase you are not using any aggregation here..
Use this as an expression
Concat(DISTINCT OrderNo, ', ' )
Becuase you are not using any aggregation here..
Use this as an expression
Concat(DISTINCT OrderNo, ', ' )
Great!
Thank you so much!
N.