To sum the spend by the distinct id

[#1]

Hi,

I have a data like

uniqueid	Spend
1	$10
1	$10
1	$10
2	$20
2	$20

i wanted to sum up the spend by the distinct uniqueid Like

uniqueid	Spend
1	$10
2	$20

using set analysis in qlikview.can anyone help me in this?

Thanks.

[johnw]

To get the chart you've indicated is as simple as making a table box with uniqueid and Spend as fields.  You don't need expressions or set analysis.  If that's not what you want, you'll need to explain your problem better.