Trending gives you the power to find hidden, yet important, patterns in your data.

Quick Facts

• You perform a trend by selecting a column, right-clicking it and selecting: Trending | ...

• You specify your Trend using business language

• Once you apply your Trend, you will see the results immediately

• You can undo your trend by pressing the Undo button

• You can modify the columns in the Trend by using Quick Calculations or Edit Calculations with the Editor

• Each trend has common options explained below

• This section discusses many of the Calculation Columns that let you transform your data into the format you need

Common Trend Options

The dialog box for each trend operation has the following options in common:

Option	Effect
Show summaries only	Default checked. When checked, the resulting trend will collapse all groupings to the summary level (thereby hiding the detail lines). When unchecked, the Trend will show summaries and details.
Hide unused columns	Default checked. When checked, the Trend will hide any column that does not have a filter and is not a part of the Trend. When unchecked, the Trend will not hide any columns.