In Chart, Pivot, and OLAPQuery reports, you generally want to override the default sort order and sort dimensional data with reference to other data. In these sections, you can use the Sort line to impose a sort condition for each dimensional data item in your report, and to nest your sort conditions at each hierarchical level of the report from the outside in.
For example, if a chart lists each type of item your company sells and the total amount sold of each, initially the item types will be ordered alphabetically. But this data becomes more meaningful when you instead sort the item types with reference to the total produced by each. This approach allows you to rank each product type from the highest to lowest total sales.
The Sort line includes three drop-down menus used to define the sort conditions. The contents of the menus vary depending on the data items in query.
Data in Chart, Pivot, and OLAPQuery sections is sorted alphabetically by default. You can use the sort buttons on the Standard toolbar to perform simple sorts on selected report items and reverse the sort order. (See Simple Sorts for more information.) |