Calculate a aggregation value on a column in obiee analysis

User_HNPXP

Hi Techies,

I had a issue to calculate the

select sum(max( employees)) as no_emp from a emp where dept in(34,56,78) group by start_date.

This the ideal scenario doing in database, but I want to get the output i.e the no_emp values in a column at BI analysis column. The columns I select in analysis are dept, start_date, end_date and have to include our calculated column (sum(max(employees)).

So finally we get 4 columns.

Can someone please help me out.

Thanks in advance,

Vicks