Skip to Content
0

Last Year / Prior Year in a Report

Nov 29, 2016 at 05:28 PM

78

avatar image

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)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Manas Phadke Jan 11, 2017 at 06:55 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nilanjan Chatterjee Jan 19, 2017 at 11:20 AM
0

Hi David,

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

Regards,

Neil

Share
10 |10000 characters needed characters left characters exceeded