SAC Planning Store wise GL Expenses % divided by Sales

[GavinMonteiro3]

Hi All,

We have a requirement for SAP Analytical Cloud (SAC Planning) Expenses planning to happen store wise using the microsoft excel add-in.
Based on the total sales value of the store, the value of each expense GL A/c needs to be divided against the total sales value.  

Expected calculation is shown below 
(Expense GL/ Income of that store)

Note - I do know there is a way to write the formula for each GL A/c and divide it by the Income GL group (in the GL Dimension)
But this would be have to be written for each expense GL A/c, which is more like hardcoding the formula for each GL A/c.

Hence, is there a way for the calculation to take the Storewise amount present in the row & divide it by the storewise sales GL grouping, without having the need to hardcode the value for each Expense GL Account ?

@N1kh1l SAP Analytics Cloud for planning Extended Planning and Analysis # any inputs in terms of achieving this requirement

So that whatever GL Accounts the user selects in the filters, system can divide that by the income GL group per store?

Regards,
Gavin.