Use one of the following workarounds
Note: These suggestions may not work if you explicitly added linking fields by clicking the link icon in the secondary dimensions window.
If you need a non-additive aggregate on the primary data source, but your data source does not support temporary tables, consider creating an extract. Tableau data extracts support temporary tables.
If you are using a secondary dimension, try changing the dimension to an attribute instead. To do that, right-click the field in the view, and select Attribute.
Important: Selecting Attribute might replace values with an asterisk (*). This indicates that there are multiple values in your data at this level of detail and Tableau can't determine which to display.
- Using the Number of Records field might be an alternative to using COUNTD, depending on your data.
If a non-additive aggregation from the primary data source is in the view, you cannot use a group created in the primary data source in the view.
- To work around this limitation, convert the group to a calculated field.
Non-additive aggregates are only supported for the primary data source, if that data source is a relational data source that allows the use of temporary tables. Non-additive aggregates are not supported for any secondary data sources.