3 Replies Latest reply: Apr 24, 2012 3:39 AM by Ashutosh Paliwal RSS

    problem with all / total

      Hello everybody:

      I have that rows

       

      año  ventas cliente

      2012  10     cl1

      2012  20     cl1

      2012  40     cl2

      2011  15

       

      The year is in a multiple selection object

       

      i need the expression that evalue the total of venta of client1 divide by the total of year

      for example  cl1 is 30 /70 for the 2012

      but the sum(all ventas) returns 85 and sum({$<año=>} all ventas) not run.

      How i obtain the sum of all ventas for the year that i selected in the multiple selection.

       

      Thanks in advance.