1 Reply Latest reply on Oct 30, 2015 10:17 AM by Daniel Vincent

    Distinct count across multiple columns

    Jonathan Haylock

      Hi All,

       

      I was wondering if someone could help me with a calculation that looks across columns and performs a final distinct count.

       

      My table is as follows:

       

      Capture.PNG

       

      I have a distinct count from three different tables all representing their own column. What I would like to do is have a total on the end of each row that looks across the three columns and performs a distinct count. The closes I can get is just getting the system to minus all three which I don't want because numbers will be repeated in there somewhere.

       

      Does anyone know how I can go about this? is this a running total question?

       

      Kind Regards