showing latest value in textbox

[#1]

AOA

I hava a bar chart showing month wise inventory in stock....

say

jan 186799

feb 195335

mar 20227

apr  25354

now i want to shw a current month inventory in text box.... which is APR where MONTH is dimension name....

and expression is =sum({<stock-={0}>}bal_amount)

kinldy advice:

[sivarajs]

use this expression

sum({<Month_No={"$(=max(Month_No))"}>}Amt)

Month_No you can get using following expression else you can use month also

date(Date#(Date,'DD-MMM-YYYY'),'MM')

[#3]

try this

sum({<month={"$(=max(date(month,'MMM')))"}>}Amt)

[er_mohit]

sum({<Month={$(=month(today()))}>}bal_amount)

[#5]

jan 186799

feb 195335

mar 20227

apr  25354

thnks to all of you who replied unfortunatly my month dimension is not a date function

its hardcoded table

time id month year

1            jan     2013

2            feb     2013

3           mar    2013

4           apr       2013

i have reload the data on 31 apr so APRIL become the latest month.

i also have a field of max_month which  giving current month i.e APR

my query is (select sum(bal_amt) where month=max_max_month) in text box

so all your replies are not working because no date involve in my sheet..

and also i dont want maximum value of amount to display i want latest

mean (max_month) value.. which is 25354

thnks

if u guys can help