How to Cascade a Report in SpotlightXL

To create a cascade report, start by opening a view that includes a specific dimension on the row axis.

1. In SpotlightXL, select Analyze > Data.
2. Select the view.
3. Under the Data subtask, select Design With > Report.
4. Select the entire spreadsheet as shown below.
   
   Note:

   Select the entire spreadsheet before using the Design Manager to ensure accurate dimension representation.
5. Click Design Manager.
   
   
6. On the Design Manager window, you can cascade row dimensions by selecting the Cascade checkbox for the dimension you want to apply cascading to.
   
   Note:

   Once a dimension on the row is selected for cascading, all other row dimensions will also be cascaded automatically.
   
7. Click the Selection icon to specify the cascade options.
8. Click Select Member.
   
   
9. The member selection window appears. Select the desired member and click Select.
   
   
10. Click the Selection icon again and select Filters.
11. Select the desired filter option.
    
    
12. Click Update. Notice that the selected dimension is preceded with Cascade. This indicates that it is a cascading dimension.
13. Optional, apply formatting as desired, such as cell color or the font size.
    
    
14. Click Save.
    
    
15. Enter a name for the report and click Save.
    
    
16. Select Run to execute the report and apply cascading functionality.

For complete information on the features within Cascade, see Cascade Reporting.