Hi all,
here's my table

MyTable

Branch Clerk transaction item value
1 1 1 1 1.10
1 1 1 2 3.25
1 1 2 1 0.95
2 1 1 1 1.10
2 1 1 2 0.50
2 1 2 1 1.10
2 2 3 1 0.95
2 2 3 2 0.55
2 3 4 1 9.99
etc...
What I need to get is average transaction value by branch by clerk
from a single query. So I need to sum values for each transaction
by clerk by branch then average those summed values so I have what I
need, average transaction value by clerk by branch. I've trie but no
luck so far. Any ideas?
Regards
Peter Gore