grouping criteria of report

[char...@sblsoftware.com]

Hi

I want to create a report which has 3 fields location date and amount

I want to take the sum based on date and location together...means...I want to find the total amount on a particular date on a particular location.

In the report wizard, I given grouping and sort criteria for date and location.

It works only independently i.e. It will provide sum for a location..and also for a date..both works independently not together.

What shoud I do

Thanks in advance