Hi all,
i have a crosstab report where I need to do a percentage calculation.
A B
US UK PARIS SA A US
Line A Div1 10 20 30 60 80
Div2 40 30 10 80 50
Totals Line A 50 50 40 140 130
Line B Div3 30 30 20 20 30
Div4 40 20 10 10 20
Totals Line B 70 50 30 30 50
Grand Total B ratio SUM(70+50+30)/SUM(70+50+30+50+50+40)
I need to create grand totals where i need to calculate
total-linesB/(total-linesA+total-linesB)
Since only total-B lines ratio need to be displayed, how do i specify the condition in grand totals.
Regards
Sam