Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Distinct count

    Hi,

    Thanks for your answer! I found that out yesterday as well after searching a while .. :/

    Thanks!

  • RE: Need current week and previous week using Date parameter

    Try and play with something like below.

    WITH MEMBER [Measures].[YTD untill previous week] AS

    Sum(

    YTD(Parallelperiod([Date].[Calendar Weeks].[Calendar Week],1,[Date].[Calendar Weeks].[Calendar Week].&[10]&[2008])),

    [Measures].[Internet Sales Amount]

    )

    SELECT

    {

    [Measures].[Internet Sales Amount],

    [Measures].[YTD untill previous week]

    }

    ON COLUMNS,

    [Date].[Calendar Weeks].[Calendar Week].&[10]&[2008]

    ON ROWS

    FROM [Adventure...

Viewing 2 posts - 1 through 2 (of 2 total)