PERIODROLLING for Annual Turnover
PERIODROLLING for Annual Turnover
I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) .
However I want to just show the last month data in the graph, is it possible. If I remove the month then the rolling function doesn't give any results.
So say I am wanting to calculate Rolling Turnover for last 12 months per Business Unit.
Period 01-Jul-2020 to 30-Jun-2021. The graph should only show Annual (last month turnover Jun-2021 per Business Unit) instead on month on month. How do I achieve this.
Tagged:
0