How i divide single rows under total

Mon, 09 Apr 2012 16:39:31 GMT

Hello everybody.

I have a next situation:

Dimension = if(left(cuenta,1) ='1','ventas a','ventas b')

expresion 1 = sum({$<mes={201011}>})

expresion 2 = sum({$<mes={201012}>})

The report show for example

expresion1 expresion2

ventas a 100 120

ventas b 80 71

total 180 191

How i generate a new expresion 3 in order to show the percentage of 100 under 180 y 80 under 180 for each row ??

Thanks in advance

expresion 3

ventas a 100/180

ventas b 80/180

CELAMBARASAN — Mon, 09 Apr 2012 16:45:55 GMT

Hi,

Check with TOTAL keyword

Expression as sum({$<mes={201011}>})/sum(TOTAL {$<mes={201011}>})

Celambarasan

topic How i divide single rows under total in QlikView