Comments

1 comment

  • Avatar
    Andy Son

    Hi Huang,

    This is best accomplished through the elastic data hub. You should create a custom column that describes whether a train is an express train or regular train.

    CASE

    WHEN LEFT([train], 1) = 'K' THEN 'Express Train'

    WHEN LEFT([train], 1) = 'B' THEN 'Regular Train'

    ELSE 'N/A'

    END

    Then you will be able to use this custom field in your pivot table and have the values merged that way.

    0
    Comment actions Permalink

Please sign in to leave a comment.