All,
I am working on a report which looks like the below.
product>>> revenue >>>>> growth percentage
a >>>>>>>12 >>>>>> 48%
b >>>>>>> 13 >>>>>>>> 52%
c >>>>> 14 >>>>>>>>>
d>>>>>> 16>>>>>>>>>>>>
total 25 100%
my requirement is to calculate the individual growth percentage of a and b with the total revenue of a and b only.
to be more specific 12 divided by 25 and then 13 divided by 25.
i want these growth percentages in growth percentage column in my report.
I achieved the selective summation of revenue for a and b in the report footer but i am not able to use the total revenue 25 (that i get in the report footer) in the body of the report(detail section) for growth percentage calculation.
I tried using shared variables and global variables but of no use.i am not able to assign the grand total in the footer to a variable in the detail section in order to calculate the growth percentage.
Is there any easy work around to achieve this? need urgent help.
I also tried running totals and stuff but of no use.
Any help would be appreciated.
Reji. 
reji2011 (BOB member since 2011-11-23)
(BOB member since 2002-08-15)