How to calculate a ratio

[#1]

Hello everybody,  new using qlikview i cant find solution to my problem:

here a little description:

i have the follow cross table in Qlikview and i need to calculate column 5 (Ratio Sales / Chimical Activity Sales).

Country1	City	Sales	Chimical Activity Sales	Ratio Sales / Chimical Activity Sales
Irland	Dublin	100	80	100/980
Japan	Tokio	200	100	200/980
	Osaka	450	400	450/980
USA	NY	300	100	300/980
	Boston	500	300	500/980
TOTAL		1 550	980	1550/980

i was trying to use TOTAL fonction but is not working

Sum([Sales / sum(TOTAL  Chimical Activity Sales]

how could i do to fixe the denominator "980" ?...

Thanks

[miguelbraga]

If so, then only change the variable given by Balraj to this:

Sum (TOTAL [Chimical Activity Sales])

This way you get what I require

[miguelbraga]

Hey Teddy,

What is your expected results? Maybe then we can help you

Regards,

MB

[Kushal_Chawda]

Create Variable on front end

vTotalSales = sum(aggr(sum([Chimical Activity Sales]),Country1,City))

Now write expression

=sum(Sales) / $(vTotalSales)

[#5]

Hi Kush i think that using aggr is a good idea but i dont know how to use the syntax, is not working.

in attached file you will find the qvw file

many thanks

Tetris