Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
'CURRENT STOCK AVAILABLE AS ON' & upper(Firstsortedvalue(month, -time_id)) & '-' & Firstsortedvalue(year, -time_id)
'CURRENT STOCK AVAILABLE AS ON' & upper(Firstsortedvalue(month, -time_id)) & '-' & Firstsortedvalue(year, -time_id)