Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Hi @ManjunathaEP ,
Not sure if I understood correctly the third requirement. For me the result would be 467 (123+344).
Regards,
Hi @ManjunathaEP,
The same way as in your previous Requirement 1 but, in this case, switching > by =.
BTW the result is 7.
Hi @ManjunathaEP,
The same way as in your previous Requirement 1 but, in this case, switching > by =.
BTW the result is 7.
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
Hi @ManjunathaEP ,
Not sure if I understood correctly the third requirement. For me the result would be 467 (123+344).
Regards,
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |