Thank you Christian Berg for your reply and sample. I have seen he sample and I have few questions. (I am sorry for below very basic questions being very new to BI)

I have customized BI subject area. I don't  have Time Subject Area in my subject area and I don't know know how to add standard "Time" subject area of Oracle BI. I assume if I have standard "Time" subject Area, I might able to solve the requirements.  One of the requirement I have I need to calculate the joined and terminated employees on the same table. For that, I am using the following formulas.

1) year("Employee Info"."Join Date")

2) month("Employee Info"."Join Date")

3) count("Employee Info"."Join Date")

The above three give me the right result of joining, However, when I add the 4th field which is count("Employee Info"."Termination Date), this does NOT give me the right result this is because my year and month is based on the Join Date and NOT on termination date.

4) count("Employee Info"."Termination Date)  This does not help me,

Therefore,  I had to create another Analysis on "Termination Date" as following;

1) year("Employee Info"."Actual Termination Date")

2) Month("Employee Info"."Actual Termination Date")

3) Count ("Employee Info"."Actual Termination Date")

The above analysis again give the right result. for terminated employees

Now, my issue is how can I make the above two analysis  in one analysis and how to add the Time Subject Area in my subject Area, it might solve the issue with Time Subject Area. Moreover, I am unable to count the employees on the each row of year and month. I mean I want to show on each year/month what was the count of the employees.

Please help.

Thanks.