Hi, would be grateful of any advice help here please.
I have a large excel data model/table and need to create a calculated field/measure for 'employee stability index' - in excel. The calculation is...
1. Total number of employees with 1+ years service / divided by / Total number of employees in headcount 1 year ago x 100
There is a row in the data set for each employee per month (data from May 2021 - June 2023), it includes a column for years service (identified as a whole number between 0 - 50). There are a number of different business units (around 60) and I need to calculate the stability index over a rolling 12 months for all of them, showing the % per month (likely as a line chart).
I need to keep the data within a pivot table so the slicers will work with the other charts.
I'm totally new to pivot chart calculated fields so I'm unsure if this is the best way or if there is another method?
Bookmarks