on 11-29-2016 5:28 PM
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)
Hi David,
You can use Offset function in EPM report to get the data of the previous month.
Regards,
Neil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.