Hi Rocco,

You could create an access rights metric in the security folder with the same dimensions as this metric, and either manually change the values or type something like IF(Year = Year."FY 26" AND Year1 = Year1."10", ACCESSRIGHTS(TRUE, TRUE), ACCESSRIGHTS(TRUE, FALSE)). You can activate that AR rule in the security settings.

This will enable write access on that cell and forbid anyone to type things on other cells.

Hi @francois,
What you are saying is more than correct,
however what I am trying to build is more than what I am showing, hence I am still looking forward a formula.
My goal is to improv on Pigment Formulas & modeling.

However, I really do appreciate your response so far,
Merci Beaucoup 

Hi @Rocco!

I hope you’re doing well! I have a few questions for you so that I can help better:

• Can you please clarify what you mean by “Hard Select”?
• Are you wanting to choose a specific value for use in a formula for another metric?
• Do you need to retain the dimensions after the “Hard Select”?

Any context you can provide will help greatly :)