i have the following standard table in Qlik Sense:
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?