Report Portal

I found my solution for calculating roll

I found my solution for calculating rolling count of weeks YTD: [Measures].[Weeks YTD] as 'Sum((PeriodsToDate([TimePeriod].[Year]),[measures].[count])' Dimension [TimePeriod] hierarchy *Year - **Week and [Measures].[count] is a distinct count of the SQL table date field used to make the Period dimension in the cube. Measures are crossjoined on rows where [Period].[Week] is on columns shows an aggregate count of weeks as time goes by then this measure can be used to calculate avg sales to date (date stored in the data not today's date) take the sales measure divide by [Weeks YTD].

 

2007-2015 VidasSoft Systems Inc.