The trouble with this is in the query which I am using, I am also summing on product code so if I set the branch to group by, I then get 6 lines of the same product rather than total for one line.
I was hoping that there would be some code such as 'distinct' that I could write into the SQL statement.
I think I will have to use separate queries to get the information I need.
Thanks for your help.