I have 3 crosstabs on my report page the first one shows before 14 days sales for which i have used filter [date]=_add_dys(current date,-14) and (current date) for the second crosstab i have same data items and used filter in second query [date]=_add_dys(current date,14) and (current date) as it suppose to show two week later sales and third crosstab should show both the summaries of before and after one below other.I have unioned the two queries but unable to get desired output.please see the scenario below:
The Scenario like below:
First crosstab
Before
Details First ApplInstall Count 1-5-2012 1-6-2012 1-7-2012 1-8-2012 1-9-2012 1-10-2012 1-11-2012 1-12-2012 1-13-2012 1-14-2012 1-15-2012 1-16-2012 1-17-2012 1-18-2012
Android PDF 258 271 269 231 212 199 187 184 185 257 197 199 169 147
Summary 258 271 269 231 212 199 187 184 185 257 197 199 169 147
Second crosstab
After
Details F AppInstall Count 1-19-2012 1-20-2012 1-21-2012 1-22-2012 1-23-2012 1-24-2012 1-25-2012 1-26-2012 1-27-2012 1-28-2012 1-29-2012 1-30-2012
Android mTablet 1 0 2 1 0 1
Android PDF 252 328 353 332 265 266 264 263 266 278 259 206
Summary 253 328 355 332 266 266 264 263 267 278 259 206
3rd crosstab
Android 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Before 258 271 269 231 212 199 187 184 185 257 197 199 169 147
After 253 328 355 332 266 266 264 263 267 278 259 206