top of page
Search

Tableau: How to Solve “Cannot Mix Aggregate and Non-Aggregate” Errors

Updated: May 13, 2021









Let’s start with a simple example. Within a single calculation, all parts of a calculation must be either aggregated or not aggregated.


This calculation is not aggregated.


[Sales] / [Profit]





This calculation is aggregated.


Sum([Sales])/sum([Profit])