Group by ID in Straight table

[James17Martin1]

Hi all,

I am very new to the QlikView scene. I am trying to group by my matter number so I can see the amount as a total per matter. I would really appreciate some help. I have attached a snippet of what my straight table looks like at the moment.

[lironbaram · Accepted solution]

hi 

if you'll drop the fields , TransType and amount from your dimension list 

you'll see one row per each matter