Straigt Table Colomns Totals in Chart

[#1]

Hi,

I would appreciate any assistance. My Problem is:

I have a Straight Table with a Coloumn A an B(the rows in  A & B are calculated from other coloumns in the straight table)  I need to use the TOTALS of both to calculate a ratio B/A. and then plot this ratio on to a guage chart. I have tried getting the totals into variables etc. but I am now stuck.

Like I said any help would be appreciated.

Cheers,

Ferdi

[#2]

if u r using the expressions in the Two columns Say...Column1 and Column2...and u want to add in the third column...

then u can write .....[Column1]+[Column2]

SEE SHEET 1

[#3]

I have tried that but it does not seem to work in a Text Object or Chart.

for example if I use =Sum(aggr((*surv_role),compID))      where C is a colomn name in a straight table.

[#4]

Sorted it out.. thanks for all the help..