Division of two sums with different parametres in a table

[#1]

Month	Category	Value
Jan	0	1
Jan	0	5
Jan	3	2
Feb	0	2
Feb	3	4
Feb	3	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

Month	Sum
Jan	3
Feb	0.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.

[#2 · Accepted solution]

Hi pavelyarygin

please see the attached example for help.

Good luck!

Rainer

[#3]

Thank you so much. My solution was the correct one but you definitely pushed me to finding the error. I had the result set as a WHOLE number so since all of the sums I got were 0.3-0.4, they automatically got shown as 0. I actually thought there was an error and I was not thinking of something essential but it was such a trivial mistake. Wasted like 4 hours on that too. Well, learned a lesson to keep an eye on the 'number' tab at least