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.
WHEN LEFT([train], 1) = 'K' THEN 'Express Train'
WHEN LEFT([train], 1) = 'B' THEN 'Regular Train'
Then you will be able to use this custom field in your pivot table and have the values merged that way.
Please sign in to leave a comment.