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:

1. Select the Model task and the Dimension subtask.
2. 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.
3. Select the Set Dimension Based Properties action. 
4. Click Save after defining number formats for each dimension.
   
   
5. Select the Analyze task and the Design View subtask.
   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.