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

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])