I have a calculated key figure Shipped Revenue that is being Calculated as Net Price * Quantity.
When I display the report by Product Hierarchy> Sales Order> Sales Order Item > Schedule Line all calculations seems correct.
But when I just want to see the report by Product Hierarchy and remove Sales Order> Sales Order Item > Schedule Line, the revenue is aggregating because the Net Price is summing up as well.
How can I make sure that the calculations are done at a line item level even when I am running the report on the Product Hierarchy level.
Incorrect after I run it for Product Hierarchy only: