How to Lock and Unlock Scaling in SpotlightXL

To use scaling in a report:

1. In SpotlightXL, go to Report > Design. 
2. Select the desired cell(s) to which you want to apply this.
3. Click Format Manager.
   
4. Select the desired option from Amount Format drop-down menu.
5. Click Update.
   
6. Click Save. When you run the report, the data will be displayed according to the selected Amount Format (scaling).