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
