@castalm ,
The formula created is not valid , look into limitations of LAC-A : Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
Please use the Arena to load the sample data. Can you then provide an example based on the data of end result what you trying to achieve ?
For eg If we take the combination [{Site}, {Week}, {Section}] ( Site1, 2.Allocated, 04/02/2024 ) .
Are you calculating the for row (Site1/2. Allocated Ticket EUE/2. February/04/02/2024) = 80 / total ( 80+19.74+60+114.37 ) ?