3 Replies Latest reply on Apr 5, 2018 5:31 AM by Jim Dehner

    Get distinct value

    Desmond soh

       

      I have a count of reversal as shown above. If you compare GBI-195 and the excel below, you can see that GBI-195 contains 17 rows of reversal and that is what I did in "columns" for the tableau. However, as i have circled in red in the excel below, I would like the count of reversal to be 4. Because i would only like to count distinct document no for those records which have reversal equals to 2. How can i do this? Thank you