How to Accumulates Sales Qty Rolling Starting From April to March

[Tofanz]

Hi All,

I have a requirement to accumulate sales qty starting from April to March in our fiscal year.

So far i tried to create a formula but still did not get what i want because the value starting from January.

this is my formula:

Sum(Aggr(RangeSum(Above(TOTAL Sum({<
[FiscalMonth]=
>}
QTY_W_SALES),0,RowNo(Total))),[FiscalMonth]))

This is the result :

 how can i get the proper formula to have "accum" value start summarizing in April not in January ?

regarding our fiscal year starting in April.

Thank You for your help,

Tofanz

[Tofanz]

Dear Sunny,

Yes I have but the amount result in each month was invalid

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[Tofanz]

Dear Sunny,

Silly me, I missed the additional selection part of your solution. it works well now
Thank you very much!

Spoiler

"Have you tried just this
RangeSum(Above(TOTAL Sum({<[FiscalMonth]>} QTY_W_SALES), 0, RowNo(TOTAL)))"