I'm trying to blend 2 data sources in **Tableau.**

When a field is brought from the secondary data source into the calculated field in the primary data source it **forces** me to aggregate at that point.

My calculation is multiplication, and when Tableau subtotals, it's doing it in an interesting way:

Formula = SUM(primary.a) x MAX(secondary.b)

Expected subtotal method = SUM(SUM(primary.a) x MAX(secondary.b))

Actual behavior seen = SUM(SUM(primary.a)) x MAX(secondary.b)

It subtotals the field and then applies the max b multiplication **after**.

Any ideas about how to control the way this calculation is done?