You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PERIODROLLING for Annual Turnover

Accepted answer
12
Views
10
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!