Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Cumulative Sum via Calculated Measure

    Please,

    Help me.

    With a dimension works.

    If you use two attributes of the same dimension:

    Year;

    Month.

    Does not work.

    Example 01:

    WITH

    MEMBER [Measures].[SALDO_INICIAL] AS SUM(NULL:Axis(1).Item(0).Item(Axis(1).Item(0).Count-1).Hierarchy.PREVMEMBER, [Measures].[QTDE_TOTAL_ENTRADAS] - [Measures].[QTDE_TOTAL_SAIDAS])

    MEMBER [Measures].[SALDO_FINAL] AS SUM(NULL:Axis(1).Item(0).Item(Axis(1).Item(0).Count-1).Hierarchy.CurrentMember, [Measures].[QTDE_TOTAL_ENTRADAS] - [Measures].[QTDE_TOTAL_SAIDAS])

    SELECT

    {

    [Measures].[SALDO_INICIAL],

    [Measures].[QTDE_TOTAL_ENTRADAS],

    [Measures].[QTDE_TOTAL_SAIDAS],

    [Measures].[SALDO_FINAL]

    } ON 0,

    [DATAS].[MES].[MES]...

Viewing post 1 (of 2 total)