Running totals per dimension MonthYear

[ishanbansal1204]

Hi Experts,

The Dataset is given below. I am facing a problem in getting the running total information.

I have a dimesnion Month_Year , I am stuck in the measure where I want to display all the <= values of the month which is displayed under dimesnion and product and dept are used as a filters

Please note this is not YTD - previous sum has to be calculated till the first value available.

Eg : For Jan - Value should be 30 and for feb value should be 75

Date	Month_year	Product	Dept	Count
1/1/2018	Jan-18	abc	xyz	10
2/1/2018	Jan-18	def	pof	20
1/2/2018	Feb-18	abc	xyz	25
2/2/2018	Feb-18	def	pof	20

[thannila]

=Aggr(RangeSum(Above(sum(Count),0,Rowno())),Month_year)

[Channa]

=RangeSum(Above(TOTAL Count,0,AGGR(RowNo(),Dept,(Month_year,(NUMERIC,ASCENDING)))))