PsiDimLock()

The PsiDimLock() function is a property function passed to PsiParamDim() or PsiPivotDim() (See the topic PsiPivotDim for examples when PsiDimActive() is used with PsiPivotDim().)

=PsiParamDim(name, range_or_array, [PsiDimLock(elem_or_index)])

The elem_or_index argument should be either the name of the locked element or its 1-based index.

Example

=PsiParamDim(“cities”, A1:A3, PsiDimLock(“LA”)) - Results in a Parametric dimension named “cities” containing three elements: NY, LA, and SF. This dimension will be locked to the “LA” dimension element.