HI All
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.
Any help would be great.
Thanks
Dan
