help in expression

[ali_hijazi]

hello

got a bar chart with dimension MonthYear (e.g. Jan-2014, Feb-2014)

the expression is sum(Sales)

ok I select the year 2014

and I get sales for the following months Jan, Feb, April

what I want now is get the last month that has sales in the above chart

how can I get the value of Apr-2014 from the sum(sales)

[#2]

Please try this:

sum({1<MonthYear ={$(=max(MonthYear ))} Sales)

[ali_hijazi]

I was thinking of using firstsortedvalue

but could not get any result

[simenkg]

sum({<MonthYear ={"$(=max(MonthYear ))"} Sales)

This will give you sales in the last possible MonthYear in the selection.

[ali_hijazi · Accepted solution]

max(MonthYear) gives Dec-2014 and this is not the case

i found this maxString({<MonthYear={"=sum(Sales)>0"}>}Sales)