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.