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 Card Tab

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

Card Tab Actions

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

Card Tab Fields

Once you add columns to your report, the following fields and actions display on the card tab:

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 card.
	Click this action to delete the current column from your customized report.
	Click this action to add a new column after the current column line.

Column Sort Order Selection Card Tab

Use this card tab to sort the columns in your report.

Card Tab Actions

Action	Description
+ Add sort order column	Click this action to open the Select Columns dialog box , where you can select the column/s against which you want Maconomy to sort the rows in your report. The Select Columns dialog box 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 list, and so on.

Card Tab Fields

Once you add sort columns to your report, the following fields and actions display on the card tab:

Field	Description
	If you want to move the current sort column elsewhere on the 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 action to delete the current sort column line.
	If you want to add an additional sort column, click this action to add a new sort column line after the current line.

Row Selection Card Tab

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

Card Tab Actions

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

Card Tab Fields

Once you select columns to filter for your report, the following fields and actions display on the card tab:

Field	Description
	If you want to move the current column and its restrictions to a different location in the card tab, click this icon and drag and drop the column line to its new location.
	Click this action to delete the current column and its restrictions.
	Click this action 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 action to delete the current restriction line.
	If you want to specify more than one restriction for the current column, click this action to add a new restriction after the current restriction line.

Row Range Selection Card Tab

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

Card Tab Actions

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

Card Tab Fields

Once you click the + Add row range action, the following fields and actions display on the card tab:

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 action to delete the specified row range values for the current report.

Preview Card

Use this card to preview the report you are customizing. If you are viewing a saved report or a finished report output, this card 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 card.