How to consolidate master - detail

Applications Grid / Reports
#1

Hi all,

I need help with the following report format :

Currently, i have this fields
dept
class
date
qty

This is sample of the datas
dept | class | date | qty
Supermarket | toys | 2014-9-1 | 2
Supermarket | toys | 2014-9-3 | 3
Dept Store | Fashion |2014-9-1|10
Dept Store | Fashion |2014-9-2|1
Dept Store | Bangle | 2014-9-1|5

What i want is to produce a grid report like this :

Dept Class Qty

Supermarket
Toys 5
Dept Store
Fashion 11
Bangle 5

Currently, if i use group by i can only come up with

Supermarket
Toys 2
Toys 5
Dept Store
Fashion 10
Fashion 1
Bangle 5

Any help will be very much appreciated.

Thank you

#2

You must group by two keys dept and class.

#3

Thank’s a lot.
I tried but didn’t put it into summary.

After i choose summary & it worked !
Thank’s

Now left with the format

#4

Then it’s solved to close the thread?

#5

Giu,

you can close it.