February 16th, 2012, 10:11 AM
advanced cross-tab needed
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:
amount 1 amount2 amount3 amount 1 amount2 amount3
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
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
place it into columns
then place table.data_your_summarizing into summarized fields.
Click Here to Expand Forum to Full Width