Your data set is very complicated and I don't know what is the best way to show expected results with filtering, but as a fact, your data is consist of below numbers.
0.5% is divided by G.total (Female smoker / Overall denom ==> must be incorrect), and 5% is Female only. (Female smoker / Female Denom)
Tobacco new_v2018.1_SM.twbx 1.5 MB
I think the Correct values is when you add dimension. Is n't it? Anyway I am getting both as 5.14% with or without. Dimension.
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread
Tobacco new_v10.5.twbx 1.5 MB