I am new to Zoho reports designs , Here i have a database where there are multiple duplicate values associated with another column with  distinct related values, the db table illustration is like bellow 

Customer	Invoice	Invoice date	Invoice amount	Receipt num	Receipt Date	Receipt amount
A	INV1	10-Feb-16	200	REC1	30-Mar-16	3000
A	INV2	11-Feb-16	500	REC1	30-Mar-16	3000
A	INV3	20-Feb-16	1300	REC1	30-Mar-16	3000
A	INV4	1-Feb-16	1000	REC1	30-Mar-16	3000
	Invoices total payed by receipt REC1		3000	Receipt amount paid for all invoices		3000

Onc receipt is paid to many invoices 4 invoices and data tables has duplicate values , 

my requirement is to summarise the receipt amount by receipt month & year for customer , from there when i view underlying data i shouild be able to see invoices under receipt 

illu:

customer             jan-16      feb-16            mar-16

A                        0            0                        3000

when i click on 3000 (mar-16 amount ) i should be able to see underlying data ,

Please help me with the report design.

Regards,

Madhav.