Crystal Report Design Problem.

I have some problem when I try to design some report by use Crystal Report. My problem is happen on Detail Section. I will tell about information first.

My Database is contain some data like this

ProductId/Amount/Members
A00001/350/N
A00001/350/Y
A00002/500/N
A00003/125/N
A00004/300/N
A00004/300/Y
A00005/75/Y

I want to report something like this

Non-Member
A00001 350
A00002 500
A00003 125
A00004 300
TOTAL 1275

Member
A00001 350
A00004 300
A00005 75
TOTAL 725
DISCOUNT 72.5


GRAND TOTAL 1927.5

How can I do it?

Insert a group, group on Members.

Insert a formula in the group header to replace the 'Y' and 'N' with "Member" and Non-Member".

Add a subtotal on Amount in the group footer.

Also search crystal help using "Group" as the keyword.

Thank you.