0 Replies Latest reply: Feb 21, 2013 11:13 AM by Anthony Lee RSS

    Use calculated expression from another object -- possible?

      Hi,

       

      My goal is to plot a scatter chart based on 2 columns (expressions) in a straight table.  However, one of the columns needs to be calculated from 2 other columns that are dynamic based on selections.  I thought I can plot a scatter chart by hiding the non-relevant columns, but it did not work. 

       

      Questions:

      1. Is there a way to do this within this object?

      2. And/Or can I create another object with a column that is dynamically linked to the calculated column of the first object?  (Would also appreciate answer to this question even if answer to #1 is yes.)

       

      To illustrate: Say I have 4 columns (expressions) A, B, C, and D in a straight table object.  Column C is calculated from the first 2 expressions (columns) -- e.g. Column C = column(1) + column(2).   Goal is to create a scatter plot using C and D.

       

      Thanking in advance,

      Anthony