Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to calculate cumulative sum but not getting desired output.
this is what i am getting:
but it must come like this:
FY_Quarter | Sales | CummSales |
FY 23-24 Q1 | 10 | 10 |
FY 23-24 Q2 | 20 | 30 |
FY 23-24 Q3 | 10 | 40 |
FY 23-24 Q4 | 20 | 60 |
FY 24-25 Q1 | 10 | 10 |
FY 24-25 Q2 | 20 | 30 |
Need your help in resolving this issue.
Thanks for your help
Hi, using the quarter number you can set the number of steps to accumulate like:
RangeSum(Above(TOTAL Sum(Sales),0,Right(FY_Quarter,1)))
It won't work if quarters are not secuential.
Thanks. Its working fine.
Can u tell me how to take difference in front end?
FY_Quarter | Sales | DiffSales |
FY 23-24 Q1 | 10 | 10 |
FY 23-24 Q2 | 20 | 10 |
FY 23-24 Q3 | 10 | -10 |
FY 23-24 Q4 | 20 | 10 |
FY 24-25 Q1 | 10 | 10 |
FY 24-25 Q2 |
20 | 10 |
If(Left(FY_Quarter,8)=Left(Above(TOTAL FY_Quarter),8)
,Sum(Sales)-Above(TOTAL Sum(Sales))
,Sum(Sales))