How to Define Multiple Number Formats for Dimension Members in Views?

This task is available for Designers and Administrators.

To define multiple number formats for dimension members in Views:

1. Specify the number format for each dimension member by doing the following:
   1. In SpotlightXL, navigate to the Model > Dimension.
   2. Select 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. Select the required Number Format.
      
      
      
2. Click Save after defining number formats for each dimension.
3. Update the properties at the View level so that the number formats defined at the dimension level are displayed as needed.
   
   
   
   1. Navigate to the Analyze >Design View.
   2. Select the view.
   3. Click the Properties action.
   4. Select the dimension from the Dimension based 'Number Format' field you applied number format to on the Model Dimension page.
   5. Click Save.
   6. Select Analyze > Data to see the results of your changes.