you are only grouping by the TranID
# suiteql
g
you are only grouping by the TranID