-
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.
-
February 22nd, 2012, 06:03 PM
#2
Re: advanced cross-tab needed
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.
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
|