![]() 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 aggregation for 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |