When using a hierarchy for reporting, is there a way to create a node that is the result of a calculation of values in other nodes? The hierarchy is built from the 0ACCOUNT characteristic. There are accounts that are grouped into lots of nodes to support P&L reporting. For example, there is a node called Gross Sales, Net Sales, Std direct cost etc. I want to be able to create/show a 'node' called 'Margin %' that would be the result of a calculation based on other node values (ex. Margin / Net Sales * 1000.) This needs to be a BEx query.
Any ideas? Thanks