Help...!!

[MK_QSL]

I have table like below...

REGION	CUSTOMER	CREDIT	SALES
A	A02	2700	100
A	A02	2700	200
A	A03	3000	200
A	A06	2700	400
A	A08	3000	600
A	A08	3000	800
A	A08	3000	300
SH	SH03	1500	200
SH	SH08	4000	600
SH	SH10	4000	800
SH	SH10	4000	1100
SH	SH20	1500	1200
SH	SH20	1500	1400
SH	SH25	3500	1600

Need output table as below

REGION	CREDIT	SALES
A	11400	2600
SH	14500	6900

This solution should be on UI side only... I don't want to handle this on script end...

[its_anandrjs]

Use Distinct with sum

Dimension:- REGION

Expr1:- Sum(SALES)

Expr2:- Sum( Aggr( sum(DISTINCT CREDIT),CUSTOMER) )