Sheet object mapping table

[#1]

Is there a sheet object in the Full Browser version which could be used as a Mapping table, so that the created Mapping Table can be used in a Calculated Dimension in a Pivot Table ?

What is a way to create a mapping table which can be used in a calculated Dimension in the Pivot Table ?

[Gysbert_Wassenaar]

No, there isn't.

You can try putting an expression in a variable:

pick(match( DimensionValue, 'MapValueA', 'MapValueB', .... 'MapValueXYZ'), 'ReplacedValueA','ReplacedValueB','ReplacedValueC',...,'ReplacedValueXYZ')

[#3]

Thanks I will try.

Is it possible to

1/ use match and pick in a calculated dimension

2/ create a new variable in the QV Full Browser version ?

Thanks again for your help