I am having a little trouble trying to work out the best architecture for a document.
I am looking at Reporter Productivity. I have:
a main table that has a field 'first reporter' and another 'second reporter'. Productivity takes into account both these fields
another table with the Reporter Details in it including the expected amount that should have been reported
Basically what i would like to do is have a table that has: The reporter name and then a count of how many times they appear in the first reporter column and another count of how many times that appear in the second reporter column, A total and also the expected.
Please see the attached example. Note i have not joined the tables yet as i am unsure on the best place to do this in this situation.
