Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Order last 13 months in MDX

    I figured out how to do it.

    SELECT [Measures].[Invoice Fact Count] ON COLUMNS,

    ORDER(

    {HEAD(TAIL(DESCENDANTS([RecvDate].[ProgMonth].[ProgMonth],[ProgMonth]),14),13)}, [RecvDate].[ProgMonth].CurrentMember.Properties('KeyColumns')

    ,DESC)

    On ROWS

    FROM [Medical Payments]

    Thanks

Viewing post 1 (of 1 total)