i have a time dimension with years, quarters, and months

in a report I need to show the last 2 months, then the last 2 quarters, then
the last 2 years, each in descending order.

I use this query to pull them

{LastPeriods(2,[FiscalDate].LastChild.LastChild.LastChild),LastPeriods(2,[FiscalDate].LastChild.LastChild),LastPeriods(2,[FiscalDate].LastChild)}


my new year starts in march, so right now this query returns (in this order):

feb 2005, march 2006, quarter 4 2005, quarter 1 2006, 2005, 2006

i need the query to return each "subset" in descending order, so my results
look like this

march 2006, feb 2005, quarter 1 2006, quarter 4 2005, 2006, 2005

I've tried different arguments to the order function but have been
unsucessful so far.

thanks!

{
Order(LastPeriods(2,[FiscalDate].LastChild.LastChild.LastChild),
[FiscalDate].CurrentMember.Properties("ID"), BDESC)
, Order(LastPeriods(2,[FiscalDate].LastChild.LastChild),
[FiscalDate].CurrentMember.Properties("ID"), BDESC)
, Order(LastPeriods(2,[FiscalDate].LastChild),
[FiscalDate].CurrentMember.Properties("ID"), BDESC)
}

or

Order({LastPeriods(2,[FiscalDate].LastChild),
LastPeriods(2,[FiscalDate].LastChild.LastChild),
LastPeriods(2,[FiscalDate].LastChild.LastChild.LastChild)} AS SetA,
Rank([FiscalDate].CurrentMember, SetA),
BDESC
)

Ohjoo Kwon


"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote

scalDate].LastChild.LastChild),LastPeriods(2,[FiscalDate].LastChild)}

thank you , that worked great!

"Ohjoo Kwon" wrote: