 |
GreatManuals.com |
|
|
ShowAs Column
<Remove> - Removes field description from report definition. Details - Always the last grid level when any drill-down Group levels are defined. If there's no group or calculation defined, the details level will look like a spreadsheet table with no drill-down levels. Note: Calculated expressions for the Details level use field name references to columns in the Field Description pulldown box or Aliases defined at the Details level. Whereas Group Calc expression types use field name references to columns that are defined at the group level or Aliases defined at the Group level, not the fields at the base or details level. Group - Start a new Group drill-down level. Group Add - Add this field to same level as the last Group drill-down level. Group Calc - Create a group level calculation vs. a detail level calculation. Example: [COUNT Order Date] / [COUNT WS#] *Note: Group Calc expressions use field name references to columns that are at the group level or Aliases defined at the Group level, not the fields at the base or details level. Whereas calculated expressions for the Details level use field name references to columns in the Field Description pulldown box or Aliases defined at the Details level. Total - Sums the field values and automatically creates a Grand Total Group and a sub-total calculation for all Groups that are defined. Count - Counts the field values and automatically creates a Grand Total Group and a sub-total calculation for all Groups that are defined. Average, Average Count, Average Total - Averages the field values and automatically creates a Grand Total Group and a sub-total calculation for all Groups that are defined. % of Total - Calculates the percentage for each grouping based on the overall grand total. You must have an additional calculation from this list (i.e. Count, Total on the same field/expression) to base the percentage on. % of Group - Calculates the percentage for each grouping based on it's parent group total. You must have an additional calculation from this list (i.e. Count, Total on the same field/expression) to base the percentage on. Maximum - Retrieves the maximum value and automatically creates a Grand Total Group and a sub-total calculation for all Groups that are defined. Minimum - Retrieves the minimum value and automatically creates a Grand Total Group and a sub-total calculation for all Groups that are defined. Unique Field - Allows you to make a unique calculation (Unique Count, Unique Total, Unique Avg) across one or more fields that are different than the groups defined in the report. Unique Count - Calculates the number of unique counts for each individual group. Unique Count Sum - Calculates the number of unique counts and sums the counts in parent group levels. Unique Total - Calculates the sum of unique values. Unique Avg - Calculates the average of unique values. Pivot Group - Formerly known as XTab Group. Works like a Group but instead of the values grouped vertically they are grouped horizontally as column headers. This functionality is similar to a pivot table in Microsoft Excel™ or a crosstab query in Microsoft Access™. All Pivot calculations work like the list above. *Note: You must define one and only one Pivot calculation whenever you define a Pivot Group. You can use the Group Calc to define additional group calculations if needed. Ignore - Just ignore this field description for now.
|
