2 Replies Latest reply: Jul 30, 2013 3:49 AM by pihu lhjklh RSS

    Division of two sums with different parametres in a table

      MonthCategoryValue
      Jan01
      Jan05

      Jan

      32
      Feb02
      Feb34
      Feb3

      6

       

      Hello. I've got a bit of a problem which I hoped someone can help me find a solution to. The original table can be found above.

       

      I need to build a table with two columns. First column is month and second column is

       

      sum({<Category = {'0'}>} Value) / sum({<Category = {'3'}>} Value)

       

      So the result should look like

       

      MonthSum
      Jan3
      Feb0.2

       

      It obviously doesn't work if I write it down like that. Can't implement this in the script either since sum(x)/sum(y) isn't sum(x/y).

       

      Thanks in advance.