getting maximum value..

[#1]

AOA

i have dimension of time having field of

(time_id,month,qtr,year)

time_id	month	qtr	year
669	dec	4	2012
670	jan	1	2013
671	feb	1	2013
672	mar	1	2013

also have cube of stock......

partno	item	time_id	qty in stock
12-2-2-2	chair	671	50
12-2-3-2	computer	672	12
12-2-3-2	computer	671	8
12-3-3-3	mouse	669	2

now is a current stock sheet i want to show heading "CURRENT STOCK AVAILABLE AS ON MAR-2013"

where MAR-2013 is a dynamic field which is a month and year of maximum time id

how can i get month and year of maximum time id in a text box to dispaly the required heading.  plz advice

[Gysbert_Wassenaar · Accepted solution]

'CURRENT STOCK AVAILABLE AS ON' & upper(Firstsortedvalue(month, -time_id)) & '-' & Firstsortedvalue(year, -time_id)