Skip to Content
0

EPM Report - 12 month Data and Totals

Dec 15, 2017 at 09:00 PM

73

avatar image

Hi,

I need to create a report with 12 months displayed and Totals in the report.

I have set a month in a cell using EPMCONTEXTMEMBER. Based on the month selected, it should display the data for each month until the month selected and for the other months it should display as 0 though it has data. Totals should be Sum of JAN to selected month.

Eg:

Month Selected is APR. In columns it should display as

JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL

10 30 50 60 0 0 0 0 0 0 0 0 150

In BPC, i have data for all months.

-- Selva.

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

1 Answer

Best Answer
Vadim Kalinin Dec 16, 2017 at 05:29 AM
0

Strange requirement, but can be done with static column axis.

Assuming that 2013.02 contain no data (use some empty TIME member)

P.S. Please read: https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/ to understand how to create axis formulas with references to some cells.


12month.png (66.2 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

P.P.S. Year TOTAL on this report can be done using local member with the formula:

=SUM(EPMALLMEMBERS)

After column axis.

Row dimension can be dynamic.

0

Thanks Vadim.

It solved my requirements.

-- Selva.

0