Post reply

Expression help again - comparing YOY dates

  • February 12, 2016 at 6:04 am

    #315830

    Sorry me again with my expressions. I have tried googling but not really getting a definitive answer.

    So I have the following fields:

    Date

    Year

    Month

    Posting Total

    Arrival Total

    So I have pulled the data into a pivot table on SSRS based on the month and year of the Date portion.

    So I need to compare YOY for the Total fields in an expression (so I can get a percentage up or down value.

    I can get the sum of the month as is as =fields!Posting Total.Value but I am having issues with the comparison of the same data for the same month of the previous year.

    Any suggestions are welcome, it's numbing my brain.

    Thanks in advance.

  • February 12, 2016 at 6:35 am

    #1858324

    Hi Kaz,

    Unfortunately there aren't any easy ways of doing this in purely in SSRS, the best way is to do the calculation in the data source.

    Are you using a database or a cube as a data source ?

  • February 12, 2016 at 6:43 am

    #1858328

    I have literally just searched for how to do it via a query so am battling this now.

    Now I have to clear out the cobwebs to work out using the dateadd without getdate and for the field haha! Friday afternoon fun.

    Thanks for the help, good to know I finally got on the right track.

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

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