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 ?
can you please give me some tips?
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.