advanced cross-tab needed

Hi Everyone,

I have an issue that I would like to see if you can help me with.

I am trying to create a crosstab that will show amount1, amount 2, amount 3 grouped by month - Jan-Dec (columns) and rows are numbered 1-31 (example:1 representing day 1 in jan). Looks something like this:
Jan Feb
amount 1 amount2 amount3 amount 1 amount2 amount3

1
2
3
4
5
6
7
8
9
10

How in the world do you achieve something like this without having to create formulas for each day of each month for 3 amounts?????

Thanks for your help everyone.

try the crosstab
place table.date into row
create a formula for amounts something like
if some condition then "emount1" else
if different condition then "emount2" else
"emount3"
place it into columns
then place table.data_your_summarizing into summarized fields.