-
February 16th, 2012, 10:11 AM
#1
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|