Skip to Content
0
Former Member
Aug 13, 2015 at 03:22 AM

Showing Key figure total on detail from Higher Level

28 Views

HI,

please see following scenario.

PROD = Product

PRODGROUP = Product Group (Products roll up to Product Group)

Planning Levels:

PL1 = Period Prod

PL2 = Period Prodgroup

Key Figures:

KF1@PL1 = Stored

KF2@PL2 = Stored

1) Can i display following in Excel (without using EPM formatting). Basically trying to show a total product group value for each product, and what percent that is of product group total

Period 1 Period 2 etc...

Prod1 KF1@PL1 , KF2@PL2 , KF1@PL1 / KF2@PL2 KF1@PL1 KF2@PL2 etc.

Prod2 KF1@PL1 , KF2@PL2 , KF1@PL1 / KF2@PL2 KF1@PL1 KF2@PL2 etc.

Prod3 KF1@PL1 , KF2@PL2 , KF1@PL1 / KF2@PL2 KF1@PL1 KF2@PL2 etc.

etc.

I am trying this with a approach similar to split factor caluclation but calculation KF1@PL1 / KF2@PL2 is always blank (not a null issue is most cases)

2) If this is possible, does KF1@PL1 and KF2@PL2 have to be stored. Can either or both of these need to be caluclated?

Thanks!