If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crosstab: Moving_Total

Started by Los, 20 Sep 2012 01:22:28 PM

Previous topic - Next topic

Los

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)

RL_Boston

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.