1 Reply Latest reply: Sep 12, 2011 2:12 PM by Anand Chouhan RSS

    TotalCount

    sandeepa rout

      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