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
