Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I have tried that but it does not seem to work in a Text Object or Chart.
for example if I use =Sum(aggr((
Sorted it out.. thanks for all the help..