Last Modified Date: 12 Dec 2016
ResolutionReplace ATTR() with MIN() in the calculated field
CauseATTR() returns NULL when there are multiple values, and all dimension values are in the scope of the grand totals row. Thus ATTR() would return NULL in the grand totals row.
By default Tableau Desktop wraps fields from a secondary data source in an aggregation in calculated fields. If this aggregation is ATTR() then the grand totals may be blank.
Additional InformationWhile replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. To fix grand total values, please see the following Knowledge Base article: Grand Totals and Subtotals Do Not Show Expected Numbers
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials