CONCAT PIVOT TABLE

[#1]

Dear all,

I have a problem with a pivot table.

I want to add an Expression that is a concat of one field.

I want to do a concat on a expression that has to be a concat where a field called NUMORDER is the highest .

I'm using sentence:

CONCAT({$<[NUMORDEN]={'MAX([NUMORDEN])'}>}[DESIM])

But it doen't work. Can someone help me

Thanks a lot

[brenner_martina]

Hi,

Concat needs a sign to seperate fields, p.e.

CONCAT({$<[NUMORDEN]={'MAX([NUMORDEN])'}>}[DESIM], ', ')

[#3]

ON expression it returns '' and there is data,

and on dimension it returns error on dimension.

Best regards