Do you have any sample data to share?
I've cleaned up some of the "real" data to hopefully illustrate what I'm trying to do. Essentially the figure at "State" is what I'm trying to fix, so that regardless of the LOD (e.g. Region) it'll still show the "State" figure (e.g. 198635 would display for NSW Metro / NSW Rural / Other on the "Region" sheet)
Fingers crossed I've attached it correctly as well!
SampleData.twbx 70.1 KB