• Hi Steve,

    I am creating a calculated measure called [LY Quantity] and this is what I have under the script view for this measure.

    CREATE MEMBER CURRENTCUBE.[MEASURES].[LY Quantity]

    AS ((existing [Fiscal Period].[Fiscal Period Hierarchy].[Day],

    {Parallelperiod([Fiscal Period].[Fiscal Period Hierarchy].[Year],1,[Fiscal Period].[Fiscal Period Hierarchy].currentmember)}),[Measures].[Quantity]),

    FORMAT_STRING = "#,#",

    VISIBLE = 1 ;

    When the user selects multiple days, I am supposed to show the Quantity from corresponding last year for those dates.

    Regards,

    Uma