Type of data in different front end table

[Abhi_WP]

I have a dimension table which holds types of employees (Enterprise Agreement, Independent Agreement). In my front-end app, I need to show the data in two tables, the first table will have all the data for Enterprise Agreement type employees and second table will have all the data for Independent Agreement. Some of the fields from different dimension are exclusive for each type of employee. For example, EA employees with have multiple level in a field called 'Emp Level' whereas for IA employees it is available in 'Rate Ref' column (in different dimension). Any suggestion on how to achieve this at front-end

[Lisa_P]

You can create two calculated dimensions which you can make as Master dimensions and then build a table from each.

One for Enterprise Employees would be:

= Aggr(Only({<EmployeeType={[Enterprise Agreement}>}Employee),Employee)

One for Independent Employees would be:

= Aggr(Only({<EmployeeType={[Independent Agreement}>}Employee),Employee)