is it possible to sum up different type of group?
For example..
a sales table contain date,brand,code,colour,size and qty
in this table there will be records that have same brand,code,colour,size but different qty.
is it possible to count the total qty by grouping the brand,code,colour,size ?