COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tamise on 14 Feb 2015 08:04:43 AM

Title: Crosstab pourcentage
Post by: tamise on 14 Feb 2015 08:04:43 AM
Hello,

I need your help in order to create crosstab with pourcentage value.
There are  the value of my table :
Year   Month   Title  SubTitle  Type   Price
2014    01     A         A1         Shirt    1
2014    01     A         A2         Pant     2
2014    01     B         B1        Shirt     6
2014    01     B         B2        Pant      7

In report studio i have create a crosstab like :

              Price
Title
SubTitle
Type

I wanted to have price on the raw Title and price/(Price of Title) for the raw SubTitle and Type

So i want :

3
(1/3)*100
(2/3)*100
13
(6/13)*100
(7/13)*100

Is it possible to do someting like this ?
Title: Re: Crosstab pourcentage
Post by: tamise on 02 Mar 2015 02:47:50 PM
can you please give me some tips?
Title: Re: Crosstab pourcentage
Post by: ravimahazan84 on 07 Apr 2015 11:38:39 PM
Hi Friend you have to customize crosstab using crosstab space in order to achieve the format.
you can refer one of my article on www.sourcetofind.com as crosstab report output in excel friendly output.