total by two dimensions in table

[#1]

Hi

i have the following standard table in Qlik Sense:

Airport	Runway	Flights	Usage
LAX	24L	160	80%
LAX	24R	20	10%
LAX	25R	10	5%
LAX	25L	10	5%
MUC	26L	150	75%
MUC	26R	50	25%

What I need is the Usage per Runway per Airport. Airport  and Runway are dimensions.

Flights = SUM(LegID).

For Usage I tried with: SUM(LegID)/AGGR(SUM(Total LegID),Airport). However didn't get the expected result.

Any idea... maybe something with rangesum/above?

Brgds Ralf

[sunny_talwar]

Try this

SUM(LegID)/SUM(TOTAL <Airport> LegID)