If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to show two crosstabs summaries one below other in third crosstab

Started by barrysaab, 08 Feb 2012 09:59:34 AM

Previous topic - Next topic

barrysaab

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
Boy! Cognos getting on to me!!!