Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find attached of the qvd.
What I have to do is I have to show the total count of personcode against m.orgcode and dw.orgcode .
Like eg:
Personcode M.Orgcode Dw.orgcode CountDifference Count(M.orgcode) Count(Dw.orgcode)
1 1 1
2 2
3 1 3 2
2 4 4 0 1 1
3 5 5
6 6 0 2 2
sum: 6 5
Please Suggest how to do it..
Thanks,
Sandeepa
Hi,
Use Count ( Total personcode ) to so total value of the personcode
Let me know if not works.
HTH
Regards
Anand