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?