Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative sum of previous quarters

Hi everybody,

I need to calculate the sum of all the previous week, for exemple if quarter 3 is selected and year 2015 is selected , i need to have the cumulative sum of quarter 1 and quarter 2 of 2015.

Here is the table in need to display:

If Quarter 3 is selected I need to have in the column " Cumul T2 Initial " The cumulative Sum of quarter 1 and quarter 2.

NB : there is a special case If Quarter 1 is selected the result must be the sum of all quarters of the last year.

Capture_LI.jpg

Thank You for your help.

0 Replies