Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have got two sets of data one containing Year & Activity & the other containing Contribution of student of various Schools in various methods.
Eg
Table1:
Year Activity
2006 ABC
2007 ABC
Table2:
School Student ContributionMethod Contribution YearA
A Jack Cash 100 2006
A Jack Kind 105 2006
A Jack Cash 110 2007
A Jack Card 150 2007
Similar data for other schools & other student as well
The two Year Variables can not be linked and have to be kept seperate .What I want as a solution is a table where when Activity ABC of Year1 is selected the highest contribution of Jack for the year is displayed
For example:
In Row 1 where the year is 2006 - Jack's highest contribution ie 105 is shown & in Row 2 where the year is 2007 - Jack's highest contribution oe 150 is shown
Please help ......
Thanks Jochem - does help a bit as I get the desired results when I select the year. Can similar results be shown without selecting a year?
Like this?
Thanks a lot - I guess I spent a lot of time trying to complicate a simple thing 🙂
I think you were!!