cancel
Showing results for 
Search instead for 
Did you mean: 

Showing Key figure total on detail from Higher Level

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Paul,

If I understand well, you try to calculate the share of the product within the product group.

Please check below blog:

Regards

Alecsandra

Former Member
0 Kudos

Thanks Alecsandra!   I wil try this.  Just curious why you dont have sales area in the root for planning area PERPRODSA and PERSA?