2 Replies Latest reply: Feb 21, 2017 10:38 AM by swana woo RSS

    How to apply selection from two fields as one selection field.

    swana woo

      I want to make some kind of favorite table..

      there is an original table chart that has all values.

      table_A:

      LOAD * INLINE [

      all

      a,

      b,

      c,

      d,

      e,

      f,

      g

      ];

       

      and another table chart that has only favorite values.(I load this table with hard coding)

      table_Favorite:

      LOAD * INLINE [

      favorite

      a,

      d,

      g

      ];

       

      and made 2 table chart for those two tables and one bar chart to show information about selected alphabet on the sheet.

      and apply selection to the bar chart from both  [table_A] and [table_Favorite].(only one selection is available from one of those tables, with table_As' field name as a selection field)

       

      I put below expression inside Add-ons>Data handlig>Calculation condition.

      GetSelectedCount([all])=1

       

      But don't know which data to put in the table chart for favorite list(values that only exist in table_Favorite).