I am developing a HR Dashboard, in which I need to show the monthly HeadCount, Addition's & Separations. Now I wish to show the Average HeadCount within the FinancialYear but Now my dimension's is Month & anyOther field Name as dimension.
For e.g.
Month FieldDept HeadCount Avg HeadCount
Apr 09 Dept1 10 10
Apr 09 Dept2 20 20
May 09 Dept1 30 20
May 09 Dept2 22 21
Mar 10 Dept 1 8 16
Apr 10 Dept 1 15 15
May 10 Dept 1 17 16
Like wise meaning out FinancialYear start's in April so the average also should get reset after the financial year end. It should only consider the month's after the start of financial year.
