Page Comparison

{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
Summaries create aggregated totals in order to provide the user with higher level data as part of a more detailed report. There are several types of summary that can be included in a table:
# Field Totals 
# Categorical Sub Totals
# Section Totals
# Section Summary Tables
# Grand Totals

Depending on the type of summary you are creating, you will have access to a selection of the following types:
# !rpt_sum.png! *Sum* - this will add all of the values in the field to create the total.
# !rpt_avg.png! *Average* - this will find the mean value of all the values in the field to create the total.
# !rpt_count.png! *Count* - this will count the number of values in the field to create the total.
# !rpt_count_dist.png! *Count Distinct* - this will count the number of unique values in the field to create the total.
# !rpt_calc_total.png! *Calculated Total* - this is only available if the field is a calculation, and uses the calculation to create the total. 


h2. AddingStandard Table Summaries
toThere aare Columntwo Reportmethods {styleclass: Class=topLink}[top|#top]{styleclass}
To add a summaryfor adding a total to a reportfield youin cana eitherstandard useColumn theor columnRow formatbased droptable:
down# menu orUse the summaryField sectionDrop fromDown thelist:
main## formatClick menuon forthe youfield's selected column.
Select the format menu and the type of summary you wish to apply. The summary will now be added to you report.

{color:#C00000}*Note:*{color} For calculated columns (eg where you have a calculated field such as Sum(Revenue) / Sum(Invoiced) ) you can add a calculated summary.  This will create a a calculated summary for accurate results (eg Sum(Sum(Revenue / Sum(Invoiced))

!00.png|thumbnail,border=1!

 
h3. Main Format Menu
If using the main menu column format drop down you will see the following options:
||Option||Description||
|*Summaries*|Choose the type of summary you wish to apply, Sum, Average, Count.|
|*Label Summaries*|If you want to include a label on the total cell then choose 'Yes'.  This will insert a label in front of the summary to indicate the summary type selected above.|
|*Sub Total*|If you wish to apply sub totals to a column you can choose the 'Yes'.  Note this will only be applied for every unique value in the column.  This option only needs to be added to the field for which you want to see the sub total breakdown.
!01sumTotal.png!|
|*Style*|The style section lets you apply formatting to your total cells.


h2. Adding Summaries to Cross Tabs
{styleclass: Class=topLink}[top|#top]{styleclass}
To add summaries to your cross tab you can either use the table field drop down menu or main menu summary option.  This option is located on the main menu and not on the individual columns as with a column report.
From the main menu you can choose to apply either column or row totals.  You can select both the row and the column totals.  This creates totals at the right hand side of the report and at the bottom of the report.

!02crosstab.png!
 

h2. Cross Tab Sub Totals
{styleclass: Class=topLink}[top|#top]{styleclass}
When creating a cross tab report you can also include sub totals on your report if you have more than one dimension defined as a row entity.
# To create a cross tab subtotal use the main format menu to select the column that the sub total is to be applied to.
# Choose the summary drop down and choose 'Subtotal'

!03subtotal.png!
 

h2. Section Summaries & Grand Totals
{styleclass: Class=topLink}[top|#top]{styleclass}
Section totals can be applied to any numeric value. When a section is added to the report an option to have the totals displayed for all numeric values is available.
# To activate this option select the section format options from the main menu. 
# Choose the section you wish totals to be applied to and click the summary drop down option:

||Option||Description||
|*Section Summary*|The section summary is a unique method of adding in a table of contents into your report.  This will create a one line summary of all sections in your report at the top of your report with hyper links to the details sections - even if you have page breaks.
Choose the section that you wish to apply the section summary for using the drop down available.|
|*Section Total*|If you wish a section total to be applied the check the tick box.
{color:#C00000}*Note:*{color} Totals will only be displayed for columns that you have already applied totals to.|
|*Grand Total*|A grand total can also be displayed at the end of the report. This will sum all the sections into one total. 
If you wish to have a grand total printed at the bottom of your report use the grand total option and click 'Yes'|drop down menu, in either of these locations:
### Through the Columns/Rows list
!01applyField.png!
### Through the Table Preview
!01applyTable.png!
## Select the Total option from the list and click on the aggregation you wish to use for the summary.
# Use the Column Formatting menu:
## Click on the Column Formatting menu in the main navigation bar of the page 
## Select the field you wish to apply a total to in the Report Fields list panel on the left of the menu
## Open the Summary section of the menu to view the available options
## Define the Total Aggregation option. 

You will notice that using the Column Formatting menu rather than the Field Drop Down list means that you have a range of additional options, rather than just the ability to select the aggregation to use. 

\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}