+ Start a Discussion
BrianWXBrianWX 

Calculate Rolling Total

I have a report to track the bookings each week.  The summarized Amount gives me the total for each week.  What I am actually looking for is to calculate how much we have booked so far at the end of each week, or the rolling total.

Example:
Week1 = $WK1_Amount
Week2 = Week1 + $WK2_Amount
Week3 = Week1 + Week2 + $WK3_Amount
... and so on

 

It believe SFDC needs to develop a new summary formula for this, but I'd like to ask experts out there if you know how to calculate this on the report builder?

 

Please like this idea on the Idea Exchange: https://success.salesforce.com/ideaView?id=08730000000knonAAA

 

Thanks,

Brian