We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
1
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!