Forum Discussion
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
Hi vicecaptain,
Right click on a column and click new hierarchy. More details here:
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
Regards,
Jimmy Tao
1 Reply
- v-yuta-msft
Community Support
Hi vicecaptain,
Right click on a column and click new hierarchy. More details here:
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
Regards,
Jimmy Tao