I have reattached your workbook with a couple of new calculated fields. A table calculation needs to be created on top of the other calcs.
Hope this helps!
tableau_example delta.twbx.zip 42.2 KB
When I try to apply the formula in difference between net (copy) within a different dataset:
ZN(([net_sales ])) - LOOKUP(ZN(([net_sales ])), 1)
I get the following error :
All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources.
We have a similar problem here: Calculated field from 2 data sources: GA and local data
Does anybody know if it's possible to bypass this error when using calculated fields across several data sources?
Unless we join the data manually before importing it in Tableau, we can't find a way to do this. And in this case Tableau becomes pretty useless...