3 Replies Latest reply on Jun 13, 2018 6:09 PM by Ken Flerlage

    Add calculated field column to table

    s k

      I created a calculated column for 'cf_last_date' from 'Last_date' to handle nulls and replace them with '12-31-1200'.

      So now this 'cf_expiry date' is shown as a calculated field and shows up in the dimension view at the end of all tables.

      Is there a way that I can add this to say table_A so it will show up under Table_A?

      And I cannot hide 'Last_date' as 'cf_last_date' is dependent on 'Last_date' and both show up in the view.

      How do I overcome these issues without creating customSql?