Create calculated field which works for multiple hierarchical columns

Hi @kachandn! It looks like the second column in the screenshot (utilization) is computing ratio(num/denom) at row level then you are doing an Average. Can you please share a screenshot of the formula for utilization column?
You may be using num/denom instead of sum(num)/sum(denom). If you use sum(num)/sum(denom) then the aggregation at the visual level will be defaulted to ‘custom’ instead of you being able to select average and will work for both SuperRegion and Station dimensions.

Corrected one

Hope this helps!
Regards,
Karthik