How to Define Multiple Number Formats for Dimension Members in SpotlightXL View

To define multiple number formats for dimension members in Views, follow these steps:

Select Model > Dimension.
Choose the model from the Model list box and the dimension that contains the members you want to define number formats for from the Dimension list box.
Select the Set Dimension Based Properties action.
Click Save after defining number formats for each dimension.
Select the Analyze > Design View.
1. Select the view and click Properties.
2. Select the dimension from the Dimension based 'Number Format field.
3. Click Save.
4. Go to Analyze > Data to see the results of your changes.

Note:

Dimension-based ‘Number Format’ and Dimension-based ‘Locked’ properties defined at the View are only applicable if the selected dimensions are defined either on row or column axis of the View.