Skip to Content
avatar image
Former Member

Last Year / Prior Year in a Report

I'm trying to develop a Category or even a measure to show Last Year data any account.

Something like this:

Time: Jan 2016

Current Year Last Year

Sales 10000 12000

The idea is that BPC "identifies" that for Jan 2016, under Last Year the value is 12000 (which is stored into Jan2015)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 11, 2017 at 06:55 AM

    David,

    If you're looking to get this result in a BO FC report, then simply having 2 columns, one with relative period set as

    +0+00 for the DP/ PE dimensions & the other with -1+00 should retrieve the desired data.

    Regards,

    Manas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2017 at 11:20 AM

    Hi David,

    You can use Offset function in EPM report to get the data of the previous month.

    Regards,

    Neil

    Add comment
    10|10000 characters needed characters exceeded