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
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
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..