please see following scenario.
PROD = Product
PRODGROUP = Product Group (Products roll up to Product Group)
PL1 = Period Prod
PL2 = Period Prodgroup
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.
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?