1 Reply Latest reply: Nov 25, 2015 6:10 AM by Marcus Sommer RSS

    Match Cjeck

    Charles Mogashoa

      Hi

       

      How do i create a dimension or expression the check another column for matching fields?

       

      As per attachment: Create a Dimension called Unique Doc No Count that will check the 'Doc no' column. If the below field does not match the above field then mark as 1. It it matches, mark the top one a 1 and the duplicates as 0.

       

      This is to enable to to filter for Unique Doc No.

       

      please below attachment for further undertanding.

      On Excel i would've used =IF(A2<>A1,1,0)

       

      Capture.JPG

       

      Regards

      Charles