I've created a crosstab that has count of employee terminations by month. The date range displayed is from Jan-10 to Aug-12. I would like to replace the count of terminations per month with the moving total for the past 12 months. How can this be done?
Thank you.
Los
(my first posting - just joined)
I've only been able to do Running-Total in a List, not crosstab. Probably have to do Case statements for each month or month range.