In Freeform tables, a total row appears at each breakdown level and can show two totals:
Under Column Settings, there are options to Show Totals and Show Grand Total. If these settings are unchecked, totals will be removed from the table. This may be desired in cases where totals don’t make sense, for instance, in certain Calculated Metric scenarios.
Static row totals behave differently, and are controlled under Row Settings.
|Which ‘total’ are the gray column percentages based on?||This depends on the Percentages setting selection under Row Settings:
|How does the Include Unspecified (None) setting impact totals?||If the Include Unspecified (None) setting is unchecked, the None/Unspecified row will be removed from the table, the Table Total, and will carry through to any calculated metrics that use ‘Total’ metric types|
|When custom table filters are applied to a freeform table, do all of my calculated metrics and conditional formatting account for the filter?||Not currently. Include Unspecified (None) will be accounted for, but custom table filters will not impact the following:
|In Calculated Metrics, what does the Grand Total metric type reflect?||Grand Total continues to refer to the Grand Total, and does not reflect filters applied to a table or the Table Total.|
|What total is shown when data is either copied and pasted from a freeform table or downloaded via CSV?||The total row will reflect the Table Total only and respects the column Show Totals setting.|