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