last 30 days sum

[#1]

hi,

i have a pivot table in tht i am using date as dimension

so my requirement is i have to show the last 30 days sum(value) for each date.

ie. for 1-5-15 , the sum(value) should take from 1-4-15 to 1-5-15

[stigchel]

This is what is called a rolling n-period, there are numerous posts about this. One that covers several solutions, examples and links to other posts is this one:

Calculating rolling n-period totals, averages or other aggregations

[#3]

Hi,

thanks...

Kindly find the attached.for 'Avg. Gross Adds (Last 30 days)' i have to calculate the last 30 days sum.

Please suggest