2 Replies Latest reply: Dec 9, 2011 4:28 AM by Gerard Santschi RSS

    Passing data between two tables (after calculation)

    Gerard Santschi

      Hi,

       

      I'm looking for a way to pass data into a new table/chart based on an on-the fly calculation in another table.

       

      Assuming I have a fruit basket:

       

      FRUITS:

      Apple

      Banana

      Pear

      Orange

      Kiwi

      Plum

       

       

      * CATEGORY  OF FRUITS:

      Cat 1

      Cat 2

      Cat 3

      Cat 4

      Cat 1

      Cat 1

       

      * I will  assign a category calculated in an expression to all of them.

       

      This is  for example based on price clusters:

      if the  price is below 1 USD/per piece, then assign to Cat 1 and so on in pre-set  clusters.

       

       

       

       

      Now, I would like to count and group the CATEGORY OF FRUITS to show the count in the clusters:

       

      CATEGORY  OF FRUITS:

      Cat 1

      Cat 2

      Cat 3

      Cat 4

       

      Count of  FRUITS:

      3

      1

      1

      1

       

       

      My issue is that when inserting the calculation from the expression (in the first table) as dimension (in the second table), I get an error message since it doesn't know the source (which fruit categories exist based on FRUITS) of the calculation.

       

      The target solution should show the grouping and the count of the fruits in the defined cluster.

       

      Is there:

      A)     a way to pass the data in the first table to the second

      B)     anyother meaningful way to solve the issue

       

      PS: It is important to keep the functionality to have the calculation of the clusters in the presented way and be done on-the-fly.

       

      Thanks.

      Gerard