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:




      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