Hello
I want to perform a table calculation (for example: Running Total ) from a calculated field that have data from 2 different data sources:
Calculated Field: A) SUM([Sales]) / B) SUM(COGS].[COGS] where A) are from a primary data source and b) from the secondary data source.
When I do (for example: Running Total or % different ) I have a exclamation marc in tableau worksheet.
If a make a Running Total just in B) it works.
The example could be found in the Superstore Sales:
Try to do a Running Total in the Calculated Field: Calculation1
Thank you very much
RFM
I asked Tracy to delete it - you had included three other datasources in with the superstore. At least two of them had sensitive information in them.
You need to make the table calculation into a real calculation by clicking customize after right clicking the pill: