Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
thanks