Column and Row Selection Tab

This section describes the fields and actions on the Column and Row Selection tab of a web Analyzer workspace.

Column Selection Pane

Use this pane to begin building your report or query. Select the columns you want to include in your customized report.

Pane Actions

Button	Description
+ Add column	Click this action to open the Select Columns dialog, where you can start adding columns to your customized report.

Pane Fields

Once you add columns to your report, the following fields and icons display on the pane.

Field	Description
	If you want to move the current column to a different location in the report, click this icon then drag and drop the column line to its new location.
Column Name	This field displays the name of the current column.
Subtotal	Select this check box if you want your customized report to include subtotals for the current column. Note: After you add a value column to the report, this check box is grayed out for all non-value columns that come after the value column.
Column Title	If you want to rename the current column, enter your preferred name in this field. Maconomy automatically updates the column name in the Preview pane.
	Click this icon to delete the current column from your customized report.
	Click this icon to add a new column after the current column line.

Column Sort Order Selection Pane

Use this pane to sort the columns in your report.

Pane Actions

Button	Description
+ Add sort order column	Click this action to open the Select Columns dialog, where you can select the column/s against which you want Maconomy to sort the rows in your report. The Select Columns dialog only lists the columns already added to your report. You can specify more than one sort column. Maconomy sorts rows against the first sort column specified, then against the next one on the pane list, and so on.

Pane Fields

Once you add sort columns to your report, the following fields and icons display on the pane.

Field	Description
	If you want to move the current sort column elsewhere on the pane list, click this icon then drag and drop the column line to its new location.
Column Name	This field displays the name of the current sort column.
Sort Order	Use this field to specify the order in which you want to sort rows against the current sort column. Available values are: Ascending - this is the default value. Descending
	Click this icon to delete the current sort column line.
	If you want to add an additional sort column, click this icon to add a new sort column line after the current line.

Row Selection Pane

Use this pane to specify criteria for selecting the records to display in your report output.

Pane Actions

Button	Description
+ Add row	Click this action to open the Select Columns dialog, where you can start adding the columns to which you want to apply selection criteria or filters.

Pane Fields

Once you select columns to filter for your report, the following fields display on the pane.

Field	Description
	If you want to move the current column and its restrictions to a different location in the pane, click this icon and drag and drop the column line to its new location.
	Click this icon to delete the current column and its restrictions.
	Click this icon to add a new column after the current column line.
Column Name	This field displays the name of the current column.
	If you want to move the current restriction to a different location under the relevant column, click this icon and drag and drop the restriction line to its new location.
Restrictions	In the first field, select an operator from the dropdown list. The dropdown includes some or all of the following options: = Equal to x…y Between < Less than > Greater than < Less than or equal to > Greater than or equal to ≠ Not equal to Ø Is empty ¬Ø Is not empty In the second field, type or select the value you want to use to filter values for the current column.
	Click this icon to delete the current restriction line.
	If you want to specify more than one restriction for the current column, click this icon to add a new restriction after the current restriction line.

Row Range Selection Pane

Use this pane to limit the number of rows displayed in your finished report.

Pane Actions

Button	Description
+ Add row range	Click this icon to display the row for restricting the number of rows displayed in your finished report.

Pane Fields

Once you click the + Add row range action, the following fields and icons display on the pane.

Field	Description
Row Start	In this field, specify the row where you want your finished report to start. The default value is 1.
Row Count	In this field, specify the number of rows you want the finished report to display. The default value is 100.
	Click this icon to delete the specified row range values for the current report.

Preview Pane

Use this pane to preview the report you are customizing. If you are viewing a saved report or a finished report output, this pane also displays a preview for that. Switch to the full screen view using the Full screen preview icon on the top right corner of the pane.