References string

[Anonymous]

Hi,

I've the following table:

Customer  Order          Article          InvoiceNr      Amount

A               100               P1               Z1500          500

A               100               P1               Z2000          600

A               150               P2               Z2200          150

A               160               P2               Z2300          800

C               350               P3               Z2400          50

C               360               P3               Z2600          1800

and I've to produce the following report

Customer     Article     sum(Amount)          Invoice References

A                    P1          1100                    Z1500 - Z2000 

A                    P2          950                     Z2200 - Z2300

C                    P3          1850                    Z2400- Z2600

How can I concatenate all the Invoice number into a simpe string field like indicated above ?

Help please, thank to anybody can put me on the right track

  

[MayilVahanan · Accepted solution]

HI

Please check the attached file

Hope it helps

[CELAMBARASAN]

Check with this

Dimensions: Customer, Article

Expressions: Sum(Amount), Concat(Distinct InvoiceNr, '-')

Do you need like this?

[Anonymous]

GREAT !!

Thanks