Inventory Totals

I use the following Mdx Expression to get the Inventory Totals
(Tail(Descendants([Fiscal Year].currentmember,[Fiscal Year
Month]),1).item(0),[Measures].[StockOnHand])

It Gives me the Following Results

StockOnHand
2003 150
Quarter4 150
Oct 120
Nov 130
Dec 150

2004 (Blank)
Quarter1 (Blank)
Jan 125
Feb (Blank)
Mar (Blank)

My Query is How Can I show
2004 Quarter 1 Total as 125 which is the Stock Position for Jan
instead of Blank
2004 Total as 125 the Stock Position for Jan instead of Blank Value

Please Advice

Regards,
Biju Francis

You want to get value of the last descendant on month as the year's value.
I think what you should do is to add a constraint NONE EMPTY on your mdx.
So try this:
(Tail(
IIf (Filter(Descendants([Fiscal Year].currentmember,[Fiscal Year
Month]),not IsEmpty([Measures].[StockOnHand])).count=0 ,
Descendants([Fiscal Year].currentmember,[Fiscal Year Month]),
Filter(Descendants([Fiscal Year].currentmember,[Fiscal Year
Month]),not IsEmpty([Measures].[StockOnHand])))
,1).item(0)
,[Measures].[StockOnHand])

the IIF just see if there exist any member's value is not empty. If no, the
Inventory total should be empty, else should be the last none empty one.

if you are sure there must be at least one none empty value in the
descendants, you may just omit the IIF.
"Biju Francis" <bijufrancis (AT) msn (DOT) com> ????
news:933ccbfd.0401042224.5acc282e (AT) posting (DOT) google.com...