Bar chart - to show unique count (restrict repeating values)

[Anonymous]

Hi,

I need to create a bar chart with the below requirement.

Let's assume the below mentioned sample data,

Customer	Field Name
A	AD
A	BG
A	BM
B	AD
B	BK
B	BM
C	KL
C	BG
C	SR
C	BM

If customer A is selected, it needs to show the unique field count used by other customers in a bar chart. For customer A, there are 2 same fields in customer B and C.

But the "Field Name" = BM is getting repeated in customer B and C, so the count needs to be 2 for customer B and 1 for customer C in bar chart.

I just need to show only the unique fields count in the chart. All help appreciated.

Attached sample data and qvw file.

Regards,

Siva

[vishsaggi]

Why customer C needs to be 1? Your C customer has a field name BG that matches customer A. Right?

[Anonymous]

Yes, the customer C has two field names matching with customer A - BG and BM. But the field BM is already matching with customer B too.

When the field is repeated again, I need to ignore them in the count. So, the result should be Customer B - 2 fields (AD and BM) & Customer C - 1 field (BG).

The unique fields matching with customer A from other customers are totally 3 fields (AD, BM and BG).