Skip to main content

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

5 answers
  1. Oct 18, 2012, 2:40 PM

    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:

     

    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.

0/9000