How to show all non-unique dimensions with Sum Expression

[#1]

Hello guys, I have a problem.

This is my Data Table

Seq	Description	Amount
203	Barton	414
204	Horton	200
205	Milton	300
206	Horton	134
204	Horton	18
205	Milton	28

Then I want it shows as:

Description	Sum(Amount)
Barton	414
Horton	218
Milton	528
Horton	134

Without showing the Seq Column.

I know it's weird to do this, but I need it to shows up like this.

I appreciate any kind of help, thanks.

[Gysbert_Wassenaar]

In the UI you can create a straight table with simply Description as dimension and sum(Amount) as expression.

In the script you can create that summary table like this:

DataTable:

LOAD Seq, Description, Amount

FROM ...source...;

Summary:

LOAD Description, sum(Amount) as SumOfAmount

Resident DataTable

GROUP BY Description;

[rubenmarin]

Hi Daniel, You can make a conditional dimension like: =Dual(Description, Seq)