Forum Discussion

vicecaptain's avatar
vicecaptain
Regular Visitor
8 years ago
Solved

Hierarchy Level mathematical Operation

Hello Everyone,

 

I have a P&L hierarchy with 9 levels. By default it gives me the sum for upper level. 
But my  MOP - Local is Net Sales - APD Net - Boutique Expenses - Distribution - SMGA - Total Cost of Sales - Comm & Fees BI
MOP - First Cost is MOP - Local (Calculated from above formula)- Total Global Expenses - Total Regional Expenses

How can I calculate these values and show it in the hierarchy.

Any suggestion is appreciated.

Thanks