2 Replies Latest reply on Aug 9, 2017 9:01 AM by Matthew Mensch

    Passing TABLE Calculated Result Values from One Data Source to Another

    Matthew Mensch

      Hello,

       

      Is there a way to have a TABLE calculation with filters on it passed to a secondary data source without adding those filters onto the new sheet?

       

      Example (THESE ARE TABLE CALCULATIONS):

      Equation1 (using Datasource1) : calculates a + b = c with filters d & e.

      Equation2 (using Datasource 2): Calculates c + x with filters y & z.

       

      I can't seem to get this to work correctly because "c" does not give me the same value in Equation 2 as it does in Equation 1 due to not having the filters d & e on the worksheet. Additionally, If I add filters d & e to the same worksheet with y & z, I do not get ANY VALUE because it is not meeting both filtering criteria.

       

      In Excel, I can simply reference a single cell, but in Tableau it does not seem to be that easy.

       

      Is there a workaround for this?

       

       

      Using Tableau 10.1.

       

      Edited: These are table calculations.

       

      Added workbook to demonstrate my issue... Thanks!