Divide the value of one row by another

[#1]

I am loading an excel file in a table like this:

ID	Property	Value
1	Property A	100
2	Property B	50
3	Property C	64
4	Property D	80
5	Property E	24

I would like to create a KPI widget that computes (Property A) / (Property B). How can this be accomplished? Along the same line of thought, is it possible to have the same thing with an aggregation?

ID	Property	Value
1	Property A	100
2	Property A	50
3	Property B	64
4	Property C	80
5	Property B	24

For instance, in this case I would want [SUM (Property A)] / [SUM (Property B)]. Is this something one can do?

[#2 · Accepted solution]

I managed to solve this using Set Analysis

Sum({$<Property={"Property A"}>}Value)/Sum({$<Property={"Property B"}>}Value)