Cumulative Sum Quarterly

[saurav5246]

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

[rubenmarin]

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.

[saurav5246]

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

[rubenmarin]

If(Left(FY_Quarter,8)=Left(Above(TOTAL FY_Quarter),8)
  ,Sum(Sales)-Above(TOTAL Sum(Sales))
  ,Sum(Sales))