Nested Grouped Plus Report type allows you to group the results of the query written on the Search Bar by two columns, one nested inside the other, and to calculate values for each group.
To create a Nested Grouped Plus Report, follow the steps given below:
1-As a first step, prepare the query for the report on the Search page as shown in the example below. Click the "+ Report" button above the search results to open the report form. The query is carried over to the form.
2-In the Report step, enter a Report Name and select Nested Grouped Plus in the Report Type field. Fill in the other fields as needed and click Next.
3-In the Query step, select the Grouped Column and the Second Grouped Column. Both fields are required. You can limit the number of rows listed under each group with Row Size. Select at least one of Sum Columns, Value Columns, Avg Columns or Unique Columns, then click Save to complete the process.