2 Replies Latest reply: Sep 17, 2017 8:02 PM by D.R.NEVILLE DHAMSIRI DHAMSIRI RSS

    How to match records which are having counting more than once

    D.R.NEVILLE DHAMSIRI DHAMSIRI

      Hi,

       

      Please see the pivot table I have created which shows cheque numbers which are having counts more than once. That was achieved by applying the following expression!

       

      SUM({<CHEQUE_NUMBER={"=COUNT(TOTAL<CHEQUE_NUMBER>CHEQUE_NUMBER)>1"}>}CHEQUE_NUMBER)

      Now I need you to help me to achieve followings!

       

      A) The cheque numbers which are repeated more than once with different customers to be chosen separately. (As you can see most of the insured are the same which records are OK  but the records where different insured are involved for same cheqe numbers to be taken separately.(How this could be achieved)

       

      B) Also help me to  pick the above records (same cheque numbers with different customers in one click otherwise I have to go down in the table to see them. The pivot table I have attached here too arranged by excluding other records (once cheque number & cash settlements) by using  CTRL key after applying the expression in the list box (cheque number dimension) which I think  do not help me in full. If you suggest me some more accurate method can be used to separately  identify them it is fine.

       

      Regards

       

      Neville