2 Replies Latest reply on Mar 27, 2012 6:22 AM by Alex Kerin

    Calculated Members

    Dave Eckholm

      I'm connecting to a Microsoft Analysis Services cube that contains date parameters such as year and month that show up in the Dimensions. I'm wondering if there is a way to identify the most recent month (max) for the current year and use in reporting to only show the sales for current and prior year for months that are less or equal to the max? 

       

      What happens now is I get sales for the prior year for weeks 1-52 and 1-10 for the current year - I would only like to see 1-10 for both years

       

      Thanks for your thoughts

      Dave