Table of Contents
Toggle💡 The video demonstrates creating a custom report with columns like first name, last name, gender, and age.
💡 Subtotals are added to columns based on specified conditions like date changes or card changes.
💡 The process involves identifying the column for the subtotal, specifying group functions, setting the order, and defining the break condition.
Here are the summary titles with time for the provided video information:
Introduction to Subtotaling 00:03
Â
Options and Break Conditions for Subtotaling 04:40
Â
Identifying Subtotal Columns and Break Conditions 08:52
Â
Group Functions and Grand Total in Subtotal Reports 13:41
A: The concept involves identifying the field for which a subtotal is needed, specifying the group functions (such as Max, Min, Sum, Average), setting the sort order, and defining the break condition to determine when the subtotal should be displayed.
A: In a report, a numerical column, such as the amount in a transaction dataset, is typically the field that qualifies for a subtotal. Subtotals make sense for numerical data, not for non-numeric fields like date or description.
A: The break condition is crucial in determining when a subtotal should be displayed. It specifies the basis on which the subtotal is calculated, such as when there is a change in a specific field like date or card type in a transaction dataset.
A: Advanced support in reporting tools enables users to specify the field for subtotals, define group functions, set the sort order, and specify the break condition. This functionality allows for the generation of subtotal lines, individual detail lines, and grand totals in reports.
SailPoint