YTD actual report on Periodic Model

[former_member250987]

Hi Experts,

System BPC Embeded 10.1

Model is periodic model

Bex query

AO 2.4

Requirement:

In the below screen shot right now data is getting displayed monthly based on periodic model.

But the requiremnt is data should be displayed in YTD , please find data format which we require in below screen shot.

Can we achieve above requirement using formula key figure in Bex query if yes please let me know how to write formula for achieving above YTD requirement.

Thanks in Advance

SK

[gregor_dieckmann · Accepted solution]

Hi,

use the current member feature in the BEx query, more details can be found here:

https://blogs.sap.com/?p=444923

Regards,

Gregor

[former_member186338]

You are talking about AO 2.4, not about

EPM Add-In for Excel

Please remove tag!