Set Analysis - Rolling 12 Months in expression

[#1]

I wonder could some one assist

I have a trend chart which is using Set Analysis. I need to work out the total count of sales for an employee over a 12 month rolling period. I work out the count of sales for an employee as follows:

Count({$<EmployeeKey={"$(=only(EMPLOYEEURN))"}>} SALES)

How could I place in an expression for a rolling 12 month period?

I'm using Year Month as my dimension.

Any ideas?

Thanks

Paul

[#2]

Hi Paul,

have you tried with

rangesum(above(Count({$<EmployeeKey={"$(=only(EMPLOYEEURN))"}>} SALES),0,12))

sorting data for Year Month?

Roberta

[johnw]

Depending on the chart, you may also be able to do properties -> expressions -> accumulate -> accumulate 12 steps back.