I have created two crosstabs that summary the order amount by product category by month. Crossrab 1 looks like
Jan Feb Mar Apr
Prod1 200 100 300
prod2 300 400 200 500
Prod3 250 340 360
And crosstab2 looks same as crosstab1, only for different location. and I am using two different report to get these two crosstabs. Althrough the two crosstab are from the same table, but the crosstab2 will use the same data as from crosstab1. cause some records will be selected in two crosstabs but they will appear in different month and by different value. that's why I have to separate them in two crosstab from two reports. I created crosstab2 as the subreport in crosstab1's report. so they are in one report now
Jan Feb Mar Apr May
Prod1 100 200 250 400 130
Prod2 240 300 340 240 520
Prod3 130 240 300 350 260
I want to get a report to summary these two crosstab like
Jan Feb Mar Apr May
Prod1 300 300 250 700 130
prod2 540 700 540 740 520
prod3 380 240 640 710 260
I know I probably can get this done by using manual crosstab. but I just want to know if there is simple/easy way to get the same result.
Many thanks!
Diana
Jan Feb Mar Apr
Prod1 200 100 300
prod2 300 400 200 500
Prod3 250 340 360
And crosstab2 looks same as crosstab1, only for different location. and I am using two different report to get these two crosstabs. Althrough the two crosstab are from the same table, but the crosstab2 will use the same data as from crosstab1. cause some records will be selected in two crosstabs but they will appear in different month and by different value. that's why I have to separate them in two crosstab from two reports. I created crosstab2 as the subreport in crosstab1's report. so they are in one report now
Jan Feb Mar Apr May
Prod1 100 200 250 400 130
Prod2 240 300 340 240 520
Prod3 130 240 300 350 260
I want to get a report to summary these two crosstab like
Jan Feb Mar Apr May
Prod1 300 300 250 700 130
prod2 540 700 540 740 520
prod3 380 240 640 710 260
I know I probably can get this done by using manual crosstab. but I just want to know if there is simple/easy way to get the same result.
Many thanks!
Diana