Total% in report studio

[kart78]

Hi,

I need total % looks like below. How to do ?

Total
               408          469          316          158     90     
%total      1                2          3              4        5               

% total 1= 408/sum(469,316,158,90)
%total2 =469/sum(408,316,158,90)
%total3 = 316/sum(408,469,158,90)
%total4=158/sum(408,469,316,90)
%total5=90/sum(408,469,316,518,90)


Thanks in Advance

[UseCog]

can u specify where actually you need this ... list, cross tab etc...

it looks like you can use an expression like,

% total 1= 408/(sum(all measures) - 408)
%total2 =469/(sum(all measures) -469
etc

Regards,
UG

[kart78]

Hi,

I am using it in Crosstab.Actually what i shown that's from Data item.for easy understand i shown like the number.
Take this scenario in GOSALES.
Doing total(Revenue) for each year for all product line.in that i need to calcualte particular year total Revenue/all the Year total Reveunue for all product line. vise versa the same for rest all the year.How to do that?

Please let me know,if u have any queries related to this..