Sum of Customers for multiple values in same column

[ManjunathaEP]

Hello, I have 2 requirements from the below sample data:

Requirement 1: I want to get the distinct count of customers, who has Y/N? equals Y and N. In the below sample data, I should get customer distinct count is 2 (Cust.Name= XYZ and ANF)

Requirement 2: I want to get the sum of the distinct customers, who have Y/N? equals Y and N. In the below sample data, I should get a sum of distinct customers of XYZ and ANF for Y and N = 610 (123+344+66+77) and also I should get the total sum of Y, who is equals to Y & N, expected answer is = 347 (123+344) 

Cust.Name	Y/N?	Amount
XYZ	Y	123
ANF	Y	344
ABC	Y	555
JUF	Y	222
KIF	Y	33
JUS	Y	55
KFF	Y	7676
LSF	Y	33
XYZ	N	66
ANF	N	77
SRE	N	88

[Payeras_BI · Accepted solution]

Hi @ManjunathaEP ,

Not sure if I understood correctly the third requirement. For me the result would be 467 (123+344).

Regards,

[Payeras_BI · Accepted solution]

Hi @ManjunathaEP,

The same way as in your previous Requirement 1 but, in this case, switching > by =.

BTW the result is 7.

[ManjunathaEP]

Hi, In the above example, I would like to get the count of the only Y, who is not Y and N.

Example: Customer Name: Total count of customers is 6 (ABC, JUF, KIF, JUS, KFF and LSF) who are not part of Y and N. Please help on this and thank you in advance

[Payeras_BI · Accepted solution]

Hi @ManjunathaEP ,

Not sure if I understood correctly the third requirement. For me the result would be 467 (123+344).

Regards,