KPI calculation problem

[felix_kraemer]

Dear all,

I have the following challenge:

I have a table containing following fields Name, Area, Sum(Revenue) and Sum(Parts).

I want to form a measure of revenue and parts. And all Areas(A-F) should be divided by the value of Sum(parts) of area E.

Can someone help me with this formula please?

Name	Area	Sum(Revenue)	Sum(Parts)	Kennzahl Umsatz / Teile ("Bereich E")
Name1	Area A	1000	0	2
Name1	Area B	5000	0	10
Name1	Area C	2500	0	5
Name1	Area D	3000	0	6
Name1	Area E	120000	500	240
Name1	Area F	10000	0	20

Many thanks,

Felix

[sunny_talwar · Accepted solution]

Try this

Sum(Revenue)/Sum(TOTAL <Name>  {<Area = {"Area E"}>} Parts)

[felix_kraemer]

Many thanks Sunny, as I am just starting to work with Qlik I really appreciate your help.