Crosstab pourcentage

[tamise]

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 ?

[tamise]

can you please give me some tips?

[ravimahazan84]

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.