1 Reply Latest reply: Apr 9, 2012 12:45 PM by Celambarasan Adhimulam RSS

    How i divide single rows under total

      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