salesforce tabular report grand total hide details wrong

SALESFORCE TABULAR REPORT GRAND TOTAL HIDE DETAILS WRONG HOW TO

SALESFORCE TABULAR REPORT GRAND TOTAL HIDE DETAILS WRONG HOW TO

Directions for how to create the original view are embedded in the workbook. The following instructions begin from the worksheet 'Example 1: original view' in the workbook in the right-hand Attachments section of this article. Afterwards all measures in the view will have to be modified to account for the additional dimension(s). Therefore to force the table calculation to be computed at the correct level of detail in the grand total, it will be necessary to add additional dimension(s) to the view. Totals are special rows that ignores the detail on the Rows shelf. Option 2: Add additional detail to the view and adjust table calculations See Configure total aggregationfor directions. See Create Level of Detail Expressions in Tableau for more information.Īfter the calculation is rewritten then the grand total can be changed using the Total using setting.

In some cases it may be possible to rewrite the calculation using level of detail (LOD) functions in place of table functions. Resolution Option 1: Rewrite the calculation using LOD functions The automatic grand total is incorrect: it shows the difference between the average sales for the entire quarters, rather than the sum of differences between the average regional sales. The option to change the aggregation type of the grand total to something other than Automatic is grayed out.įor example, the view shows the difference in average regional sales between quarters. IssueWhen using table calculations, grand totals and subtotals might show unexpected results.

Salesforce tabular report grand total hide details wrong