One Data field dependent on another?

[dasadler]

I am making this org chart and the various position shapes have a custom data field called 'LEVEL' with possible values of Exec;Sr;Assoc;Jr;Vacant

I would like to have another field named SALARY so I could have various salaries linked to the LEVEL field value.  Possible values would be $70,000;$50,000;$35,000;$30,000; $0

In other words, if I select Vacant as the LEVEL value, the SALARY value would automatically be $0.00 and if I select Exec as the LEVEL value, the SALARY value would automatically be $70,000

How can I do this?


My objective is to do 'What If' analyses of various hiring scenarios. This means that I will need to see the sum of all salaries.

[Jumpy]

If the possible values for "Level" are in a Format-Cell of the ShapeData in the ShapeSheet,
you can create a fitting list for Salarys in another ShapeData-Cell or in a user defined Cell.
Than you can use a combination of the ShapeSheet-Functions INDEX and LOOKUP do show you the fitting salary-value to a selected Level in a further cell.

Sth. like:
=LOOKUP(INDEX(Prop.Level,Prop.LevelFormat),User.SalaryList)