Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. My question on picture:
Try this with changing underlined values according to your requirement
If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month ) )
change your expression as follow:
if(dimensionality()=1, sum(Sales),
if(dimensionality()=2, your expression))
thanks. but I need calculate month values also with accumulation
What value you want to display at months.exactly??
AcumSales
MonthDim | DayDim | Sales | AcumSales |
---|---|---|---|
Apr | 7 | 7 | |
1 | 1 | 1 | |
2 | 2 | 3 | |
3 | 4 | 7 | |
May | 5 | 12 | |
1 | 1 | 8 | |
2 | 2 | 10 | |
3 | 2 | 12 |
Try this:
if(Dimensionality()=1,aggr(rangesum(Above(aggr(Sum(CA),Month),0,RowNo())),Month), rangesum(Above( Sum(CA),0,RowNo())))
Per analogy, I would have:
Try this with changing underlined values according to your requirement
If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month ) )
Thanks!
Glad it helped you