Hi

I have a tabular report as follows:

Code:
--------------------------
Region | Sales | Percentage
--------------------------
  X    | 100   |   16.67
  Y    | 200   |   33.33
  Z    | 300   |   50.00
--------------------------
Total  | 600   |   100%
--------------------------
How do i use the total sales value to work out the individual percentages and the total percentage value?

I use the following expression to give me the individual percentages but how to I add these up to give me the total percentage?

Code:
=Field!Sales.Value)/Sum(Field!Sales.Value,"Tablix1") * 100