Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following dimensions year-calendar week.
Now i want to have a cumulative sum per year.
But should always start at the beginning of the year.
This formula does not start at zero at the beginning of the year in an line diagram. in an tabel it is fine.
I do not find a solution.
RangeSum(Above(Sum({<TYP={'SALES'}>}PRICE),0,RowNo()))
Create Week(DATUM) as Week in the script and then try this
Aggr(RangeSum(Above(Sum({<BELEGTYP={'AB'}>}GESPREISNETTO),0,RowNo())), GESCHAEFTSJAHR, (Week, (NUMERIC)))
Try this
Aggr(RangeSum(Above(Sum({<TYP={'SALES'}>}PRICE),0,RowNo())), FiscalYear, (Week, (Numeric)))
Hi Sunny !
If I use the so, the line runs to 0.
What are the two dimensions that you use in your chart on the right?
KW
Dual(Num(YEAR([DATUM]),00)&'-KW'&Num(Week([DATUM]),00),Num(YEAR([DATUM]),00)&NUM(Week([DATUM]),00))
Nettopreis
Aggr(RangeSum(Above(Sum(.........
Not talking about the line chart.... but the chart next to it... What are the two dimensions used here?
2015/2015 or 2016/2017 is fiscalyear.
the other one is the week from an datefield.
Have you used these two dimensions in your chart? Would you be able to share a sample?
No i have used other.
How can i shared it with data?
Look here on how to upload: Uploading a Sample