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 the Analyze task and the Data subtask.
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 required member and click Select.
   
   
10. Click the Selection icon again and select Filters.
11. Select the required filter option.
    
    
12. Click Update. Notice that the selected dimension is preceded with Cascade. This indicates that it is a cascading dimension.
13. Apply formatting as required, such as highlighting cells with a color and adjusting the font size as necessary.
    
    
14. Click Save.
    
    
15. Enter a name for the report and click Save.
    
    
16. Go to Repot > Run to execute the report and apply cascading functionality.
    
    

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