In addition to configuring rows, you can also configure how you want your data to appear in a report using the Sort and Filter functions in the Table component.
Sorting orders your data by a single data key or list of data keys. There are three types of Sorting in Tables.
Basic and TopN sorts can be configured for either ascending () or descending () sorts. They can also utilize aggregate (calculation) keys.
The TopN sort option, Include Others if selected, will include all values outside of the specified Count range by compressing them into a single row.
The CSV dataset containing all the data and the table used for the following Sort and Filter examples are shown below.
Filtering gives the option of processing data based on an expression. The Filter Key property can be found in the Property Inspector under the Properties tab.
This example is sorted in ascending order using the Subtotal data key, and filtered for any 'Subtotal>1000.' To alternate to descending order, click the Ascending icon ( ) to toggle to a descending sort.