Pick and Match combination will come in use when to view field value ‘x’ when field value is ‘y’.

Example:

Display Quarter value as Q1, Q2, Q3 and Q4. Instead of showing database values.

Pick(MATCH (-1,TIME_CALENDAR_QUARTER = 1, TIME_CALENDAR_QUARTER = 2, TIME_CALENDAR_QUARTER = 3,-1), ‘Q1’, ‘Q2’, ‘Q3′,’Q4’) as TIME_CALENDAR_QUARTER