Using aggr

[jduluc12]

Hi,

My sample table looks like

ID-1	ID-2	NAME	AMOUNT
1	10	A	10
1	11	B	20
1	12	C	30
6	21	A	25
6	22	D	30
30	31	E	40
30	32	C	50

The expression I am looking for is

if the total amount per ID-1 exceeds or equals a certain number, say 60, then show all NAME associated with that ID along with the amount.

so the total amount per ID is

ID-1	AMOUNT
1	10+20+30 = 60
6	30+25 = 55
30	40+50 = 90

So, the output should be

ID-2	NAME	AMOUNT
10	A	10
11	B	20
12	C	30
31	E	40
32	C	50

Thanks,

Jean

[hic · Accepted solution]

You probably don't need Aggr() for this. Try using "ID-2" and Name as dimensions in a chart (table or bar chart) and
Sum({<"ID-1"={"=Sum(Amount)>=60"}>} Amount)
as Measure.

[jduluc12]

Thanks, Hic...it worked