Skip to Content

EPM Report with Actuals and Plan Data

Jan 16 at 09:29 PM


avatar image


I need to build a report with both ACTUAL and PLAN data based on the month selected. If a user selects JUN 2017, Data from JAN 2017 to JUN 2017 should be ACTUAL and JUL 2017 to DEC 2017 should be displayed as PLAN data. Also, ACTUAL and PLAN data needs to be color coded for differentiation and ACTUAL data needs to locked from user entry four input.

Color coded Blue is from JAN to JUN with ACTUAL and the cells are locked from data entry.

Color coded ORANGE is from JUL to DEC with PLAN and user can input data to change plan values.

-- Selva.

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

1 Answer

Best Answer
Vadim Kalinin Jan 17 at 08:35 AM

You can use static column axis with CATEGORY member calculated using Excel formula. Color formatting can be done using Excel Conditional formatting.

I have answered this question number of times, why not to search?

10 |10000 characters needed characters left characters exceeded