Thanks for the tips. Yes, this is helpful to me in creating the static tables:) However, do you see a possibility in creating a flag / master dimension which i can easily use it in other tables and charts? I was thinking with that i should be able to compare the data sets between those with and without the conditions - which i had attempted to create the flag as master dimensions but without success.
Meanwhile, i will explore using variables in the expressions you provided to create the flexibility for users to conduct scenario tests.
Million thanks again!