How i divide single rows under total

[#1]

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 · Accepted solution]

Hi,

     Check with TOTAL keyword

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

Celambarasan