Hi,

There is a employee table with 4 columns. The column values are employee first name, last name, age and location. One employee can have multiple records.

The first three columns value does not change for any employee. Only the last field value changes. Eg. if a employee have 4 records, then it means first name, last name, age remains the same and the Location only changes. Please refer the attachment.

Now the requirement is, if a employee has 4 records, then instead of showing all the 4 records, i have to show only ONE row , with fields such as First Name, last name , Age and the fourth column 'Location' should be a drop down which should show all the 4 different locations. Is this possible? I am not sure how to integrate a drop down inside a OLAP table. Your help would be greatly appreciated.