COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: orbair on 30 Jun 2014 05:17:56 AM

Title: Crosstab issue
Post by: orbair on 30 Jun 2014 05:17:56 AM
Hi All,

I have a crosstab  - columns are weeks, rows some calculations
   Week1   Week2   Week3
revenue   1   2   3
rate   1   2   3
orders   1   2   3
...         
time   02:36   04:12   01:33
Title: Re: Crosstab issue
Post by: orbair on 30 Jun 2014 05:21:05 AM
Sorry, I posted by mistake

So the time is not showing this way

   Week1   Week2   Week3
revenue   1   2   3
rate   1   2   3
orders   1   2   3
...         
02:36         
04:12         
01:33         

Can you please advise. If I use as measure it counts.
Thanks
Title: Re: Crosstab issue
Post by: Chandrasekar on 02 Jul 2014 02:18:04 AM
Hi,

In cross-tab measures represents in row wise that's correct. If you want in time count, use list box.

Thanks & Regards,
Chandrasekar.