Rolling 8 Months

[#1]

Hi All

I have period as one of the filters in my report. The format of the period is '200701','200802', '200903' etc ( 'YYYYMM')

I need to display the rolling 8 months in a pivot table as one of the columns?

I would really appreciate if any one of you could provide me some inputs? I tried RangeSum() function, but I am not sure whether it will work in all the cases?

Thanks

Karthik

[#2]

Hi Karthik

I assume you want to calculate rolling 8 months from todays date. Rob Wunderlich has created a good application to handle date ranges, where he creates a simple calendar and creates date ranges which you can modify according to what you want.

I attached his Cookbook.qvw for your easy reference; otherwise, click in on RobWunderlich.com

[#3]

Hi Karthik,

see the attached application for testing.

Here are the expressions for Rolling8Month:

RangeSum(Above(Sum(Value),0,8))

RangeAvg(Above(Sum(Value),0,8))

Rainer

[#4]

@Jeanne,

Thanks very much for your reply. I will look into it.

@Rainer

Thank you for your reply.

But I am afraid that will work because I dont have periods in my table.