Series configuration to add up values

Hi All,

  We have a requirement to show up summed up history values in worksheets.  We need to create a custom series 'Last 4 Period Total History'. The series should sum up the history for the last 4 periods. So when we display the worksheet in weekly bucket, the custom series should sum up the history for the last 4 weeks.

 

  When we use monthly buckets to display the worksheet, the custom series should sum up the history values for the last 4 months and display it in the worksheets.

 

  Has anyone come across a similar requirement or has anyone worked on client expression to sum the values of a series in two different time periods. Is it possible to display as mentioned ?