Help with expression

[#1]

Hi All,

I am trying to show percentage(marked in yellow) of indivdual values to sum of total values

Here i need to achieve ration (individulas to total) in an expression ...

Year	Vendor	Units	Ratio
2012	A	30000000	42.85%
2012	B	26000000	37.14%
2012	C	14000000	20.00%

[#2]

can  u explain more ?

[#3]

i guess the expression for caliculating ratio will be  ...

=num

(

sum(Units)

/

Sum(TOTAL <Year> Units),'#.##%')

[#4]

Please correct me if i am wrong

[#5]

yes,it shud work...

haven't u tried it yet ?

[SunilChauhan]

sum(Units)

/

Sum(TOTAL <Year,Vendor> Units),'#.##%')

hope this helps