Post reply

How do I get data for last 13 months grouped by Month

  • February 6, 2014 at 11:27 am

    #287992

    Hi,

    I am very new to MDX. I have a cube and I am creating a SSRS report. The requirement I have is I need to create a graph showing loan data over a period of last 13 months. I put the below filter in where clause to get last 13 months data.

    [Date].[Date Hierarchy].currentmember.lag(12):[Date].[Date Hierarchy]

    But the results show sum of loan over last 13 months. I want my query to show the loan per month like

    Jan 2013 - Loan Value

    Feb 2013 - Loan Value

    March 2013 - Loan Value

    Please help !

  • February 6, 2014 at 11:45 am

    #1686715

    Please don't post in several forums, you'll just divide the possible help given to you.

    All answers should go in: http://www.sqlservercentral.com/Forums/Topic1538780-391-1.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

You must be logged in to reply to this topic. Login to reply