Multiple records in one expression

[easternfish]

Hi,

I'm trying to combine multiple record that are related into same line.

Exp:

this is how my reports looks

ID	Description	Total
A	Item 1	$200.00
B	Item 1	$100.00

this is how I want it to look.

ID	Description	Total
A-B	Item 1	$300.00

please let me know how this can be achieve.

thank you so much in advance!

[sunny_talwar]

In the script or in the chart?

[Gysbert_Wassenaar]

Perhaps like this:

LOAD

     concat(ID, '-') as ID,

     Description,

     sum(Total) as Total

FROM

     ...source_table...

GROUP BY

     Description    

     ;

[easternfish]

how would that work if the ID comes from a different Source Table and linked by description?

[easternfish]

I was trying it in the chart originally.

[sunny_talwar · Accepted solution]

Then try it like this

Dimensions

Aggr(Concat(DISTINCT ID, '-'), Description)

Description

Expression

Sum(Total)

[easternfish]

Thank you for all your help!