Merging columns is a way to combine information.
- You can merge several columns into a single column, and then format, sort, aggregate and filter data in the merged column.
- You can create a summary table that presents aggregate data information in a report, providing users with a concise view of the data. The aggregate calculation occurs at the data source level, which enables users to quickly view summary information at a glance (also known as a contextual call-out) Provides information and actions in a dialogue box for an item on the screen when the user right-clicks or taps the item., improving response time and reducing the load on the server.
You can format, sort, aggregate and filter data in a merged column.
- Select a merged column and click tap Filter from the context menu.
- From the drop-down list in the Select Data Item dialog box, select the data item or column to modify.
- Click Tap OK.