Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share a sample where we can see the issue?
Dear Sunny,
Silly me, I missed the additional selection part of your solution. it works well now
Thank you very much!