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

[beck_bakytbek]

sorry, it doesn't show anything

[sunny_talwar]

Would you be able to share a sample app?

[beck_bakytbek]

Of course Sunny,

you find my problem under expression: M2 plus test 2

Thanks a lot

[sunny_talwar]

May be this:

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

[beck_bakytbek]

Sunny Thanks a lot for your Help and Taking the time to find Solution

Thanks a lot