Reverse accumulation

[agni_gold]

Hi Experts,

I have made on bar chart , in which

Dimension : Day (1,2,3,4,5,6,7,... so on ) -------  Sorting order is ascending

Expression : sum(amount)

Full accumulation option is check in

Now i have changed the dimension sorting order to descending .

Now my chart is look like.

I just want , amount at day one should be at 9th day (like reverse).

Also attching the example file .

Please help.

[sunny_talwar]

Try this:

RangeSum(Below(sum(Amount), 0, Day))

[agni_gold]

I have tried your expression in my actual application , like below

=Rangesum(below(sum({<Date= {">=$(=min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,Day))

But it is showing amount at 9th day only

[sunny_talwar · Accepted solution]

Try with RowNo() instead of Day

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,RowNo()))

Also make sure to add Date function around Min in your set analysis unless you date is a number.

[swuehl]

RowNo() will not accumulate to the bottom line:

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,NoOfRows()) )

or

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,(NoOfRows()-RowNo()+1)))

[agni_gold]

Thanks Sunny ,

I have tried in this way

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,)Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }Day))

It is also working ,

Am i doing correct ?