PROBLEM WITH EXPRESSION

[adiarnon]

HI,

i have a table-

catalog number	month	order no	qty
a	1	1	10
a	1	2	10
b	1	3	10
c	1	4	10
c	1	5	10
c	1	6	10
d	1	7	10

i want to get a table

catalog number	month - 1
catalog number	sum(qty)	orders nums
a	20	1,2
b	10	3
c	30	4,5,6
d	10	7

i have a problem with the orders nums column.

its working only if there is only one order...

can i do that somehow?

tnx...

[alexandros17]

Here it is an example

[adiarnon]

can i do that without changing my scheme?

[alexandros17 · Accepted solution]

Here it is as you want

[MK_QSL]

Create a straight table

Dimension = catalog number

Expression

SUM(qty)

&

Concat(Distinct [order no],', ')

[alexandros17]

Hi Adi,

even my answer was correct ...

[adiarnon]

hi,

sorry, but i cant choose 2 correct answers.

next time it will be yours

[MK_QSL]

Hi Adi,

Honestly speaking,  whenever you get more than one correct answer,  try to select correct one which was posted first.

Also,  if more than one answers are correct,  you can select helpful also.

In this case Alessandro's answer should be selected as correct and my one as helpful.

Thanks for your understanding.

[alexandros17]

Thanks Manish ... it does not matter however and I' happy you received the points!