About sorting, filtering and organizing data
Interactive Viewer enables you to organize report data in several ways. You can change the width of columns, and move and remove columns to improve presentation or change the order of data in a report. You can sort data in a column in ascending or descending order, organize data columns into groups, and create computed columns. You can create aggregate data such as sums, standard deviations, rankings, and differences. You can also use Interactive Viewer to change group and column headers, and to customize pagination in a multipage report by defining page breaks before or after groups.
You can hide columns as well as report elements based on your needs. You can also hide duplicate data rows in a column, or a group. You can use Interactive Viewer to create calculations to count items in a warehouse or provide more complex financial data, such as tracking stock portfolio performance over time.
Oftentimes, a report or report element provides more information than you need. You can display specific rows of a report by using a filter. For example, instead of listing all customer sales, you can create a filter to list only the sales data for a particular week or a specific region. Filtering data helps you work effectively with large amounts of data. This document describes how to perform each of these tasks.