Hi Guys,
I have a requirement to create custom Total Annualized Turnover rate column in crosstab, which renders the Turnover rate per year.
I have created a crosstab to render turnover rate for each employee status(row) by department(column) and rendering the total turnover for each employee status at column level using total function from RS menu.
Now, to calculate the Total Annualized turnover rate, i'm using the same total function from RS menu and changed the 'Define contents' to 'NO' and written a custom expression using the 'Report Expression' data type and even specified the Properties to define the scope. but this column didn't provide the accurate values.
Example Total Turnover for each employee status is 100% the Total Annualized Turnover is (100*12)/maximum_month_number (if we have 6 months data then max month is 6)
If any one have gone through this kind of custom calculated column in crosstab share with me.
Thanks in advance