Skip to Content

EPM Report - 12 month Data and Totals

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 16, 2017 at 05:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded