Distinct Help !!

[dhanu_today]

Hi Everyone,

I need some help to get the below requirement.The data and out put as below.

Data:

Region	Cust_id
West1	ABC
West1	CBC
West1	BCA
North1	BCA
North1	BZC
South1	ABC
South1	BBB
South1	BBC

The output is like;

Region(Dimension)	Count(distinct Cust_id)
	6
West1	3
North1	2
South1	3

Req:

The 6 is expression total in staright table.When we make the sum its showing the count as 8.But the requirement is we have to show the distinct cust_id's region wise.To do this we have to consider only count as 1 for the cust_ids available in multiple regions.E.g.BCA is available in both West1 and North1 so then we have to consider the count as 1 at any one of the region.The same logic is for ABC as well.I have to do the same in design level is an added advantage.

Let me know if in case of clarity required.

Thanks in adv,

Dhanu

[dhanu_today]

Thanks Manish.It seems working in backend and is any chance to apply the same in design level because of the Region and cust_id fields are coming from diff tables with the combination big data model.

Dhanu

[MK_QSL]

Will try and come back to you on this