only last value

[beck_bakytbek]

Hi Folks,

i have one problem,

i use this expression:

M2:

sum(aggr(rangesum(below(total sum({<Month=>}Amount),1,2)),Month)) ,it does work great,

but i want see only last value of selected period, how can i make invisible other value / or to set to Zero.

thanks a lot

beck

[sunny_talwar]

May be this:

FirstSortedValue(Aggr(RangeSum(Below(TOTAL Sum({<Month=>}Amount), 1, 2)), Month)), -Month)

[Anonymous · Accepted solution]

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Month=>}Amount),1,2)),Month))

)

[beck_bakytbek]

Sunny

Thanks a lot

[beck_bakytbek]

Robin

Thanks a lot

[beck_bakytbek]

Hi Robin.

i have one question, i have in this case two types of amount, and when i use the set expression, my expression doesnt work

2 types of my amount: UK and USA

i use this expression:

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Type = {'UK'},Month=>}Amount),1,2)),Month))

)

do you have any idea?

thanks a lot

beck

[beck_bakytbek]

Hi Sunny.

thanks for your feedback,  i have in this case two types of amount, and when i use the set expression, my expression doesnt work

2 types of my amount: UK and USA

i use this expression:

if(rowno(total)=noofrows(total),

sum(aggr(rangesum(below(total sum({<Type = {'UK'},Month=>}Amount),1,2)),Month))

)

do you have any idea?

thanks a lot

beck

[sunny_talwar]

Not certain, but may be this

If(RowNo(TOTAL) = NoOfRows(TOTAL),

Sum({<Type = {'UK'}>} Aggr(RangeSum(Below(TOTAL Sum({<Type = {'UK'}, Month=>}Amount), 1, 2)), Month)))

[beck_bakytbek]

Hi Sunny,

thanks a lot for your help,

but i implemented this code in my expression, and it does not work

beck

[sunny_talwar]

When you say it doesn't work, do you mean it gives an error? doesn't show anything? show incorrect result?