Setting The Group Order And Sum Function

The column and row areas of the cross-tab are considered the groups. With either of these fields selected in the Format Cross-Tab dialog box, the Group Options button becomes available. Click, this button and the Cross-Tab Group Options dialog box opens. Here you can change the order in which the group data prints on the report and create a custom name, “Sorting, Grouping, and Totaling Data on Your Report.”

If you select a field in the Summarized Field list, the Change Summary but­ton becomes available, allowing you to change the summary operation.

Other Cross-Tab Options

Several options are available depending on what field you select: a column, row, or summarized field.

•   Remove. Select a field and click Remove to remove it from the cross-tab.

•   New Formula. Click this button to launch the Formula Editor and write a new formula. The formula is added to the Available Fields list and can be inserted into a cross-tab section as a row, column, or summarized field.

•   Browse. Click Browse to browse the field data for a field.

Cross-Tab Formatting

You have many options for formatting your cross-tab to look just the way you want. You’ll find the first set of options on the Style tab of the Format Cross-Tab dialog box. Select a formatting option and sec the preview of that formatting option in the right-hand panel. Most of these options involve cell borders and color to help separate your data from the totals and column headings.

About Author

Leave A Reply