Post reply

report with previous year and current year's data and previous year's current month and current month data

  • March 15, 2012 at 3:28 am

    #265833

    Hello guys

    I need help with the report I'm doing

    I've got to report for previous and current year's data and previous year's current month and current month of the current year

    I read data from a stored procedure, now I want create a report out of that data

    I've attached a spreadsheet with results needed and with raw data.

    Please help 🙂

  • March 16, 2012 at 4:09 am

    #1460394

    Either in SSRS or in yor query, you need to break the data into current year and prior year creating a field for current year values and a field for prior year values. Then you can place those on a matrix or table and calculate the variance by subtracting the two.

  • March 16, 2012 at 4:19 am

    #1460400

    Thanks

    I was able to figure it out yesterday and it works perfectly.

    🙂

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

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