rolling 12 month

Hi all, I'm attempting to do a simple 12-month turnover rate: Employee Separations / Avg Employee Headcount over 12 months However, the dataset I have has employees appearing multiple times as they are split over multiple roles. Initially, to overcome this issue for getting my rolling...

Hi, I have two tables first one is showing number of involuntary resignations each month during 2017, 2nd table resignations during 2018 for locations A,B,C,D,E, F, 3rd table shows the total headcount by month for 2017, and last table is headcount for 2018. My question is: how to calculate...

Hi All, I'm really struggling with a formula I need to work out, not sure it can be done? I have a very short deadline with this, all help appreciated. The formula I have put together is the following =SUMPRODUCT(--(Table_Query_from_******_Ltd3[STOCK_CODE]=A8)...

In powerpivot excel 2016 i write a formula to sum year to date sales using filter function as below: SalesYTD:=CALCULATE ( [Net Sales], FILTER ( ALL ( Sales), 'sales'[Year] = MAX ( 'Sales'[Year] ) && 'Sales'[Date] <= MAX ( 'Sales'[Date] ) ) ) And it's work perfectly now in...

Looking for solution to compute the rolling twelve month sum but when part of the data is from the current sheet and one other sheet. It is the monthly totals at D35, F35, H35 etc that are used for the rolling 12-month totals. Excel WorkbookBCDEFGHIJKLMN1*Sheet 2***********2DayJan 16*Feb...

I tried to follow Jon Peltier’s April 24, 2008 post concerning a Dynamic Chart using Pivot Table and Range Names to create a 60-week Dynamic Rolling Chart. The chart generated fine and adds new data but how do I get it to capture only the last 60 weeks? Information: • OS: Windows 7 Enterprise...

Hello, I am throwing in the towel and asking for help... I have been trying to find a formula that will track the sum for a range of cells and exclude any rows in which the date is more than one year old. Here is the data (I mocked up a visual aid using a table below): Dates will be entered in...