QTD

Description:

This function is used to return a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension.

Syntax:

Qtd( [ Member_Expression ] )

Return type:

SET

Parameters:

Parameter	Description

Parameter	Description
Member_Expression	It is a valid MDX expression that returns a member.

Example:

MEMBER [Measures].[QTD Sales] AS
        SUM(QTD([Date].[Calendar].CurrentMember), [Measures].[Internet Sales Amount])
    MEMBER [Measures].[QTD Prev Quarter] AS
        SUM(QTD([Date].[Calendar].CurrentMember.Lag(3)), [Measures].[Internet Sales Amount])
    MEMBER [Measures].[QTD Growth %] AS
        IIF([Measures].[QTD Prev Quarter] = 0, NULL,
            ([Measures].[QTD Sales] - [Measures].[QTD Prev Quarter]) / [Measures].[QTD Prev Quarter]),
        FORMAT_STRING = 'Percent'