Hi Experts,
I have created query which is using simple formula as Amount = Price * Quantity.
The query is using hierarchy on Material.
When I drill down to the lowesr level (leaf node) the formula is showing correct result.
But at all the node levels its displaying incorrect result.
Ex.
Mataterial 1 Rate = 4 Quantity = 10
Maaterial 2 Rate = 3 Quantity = 10
In hierarchy both the se materials are under same node (Parent node) say Node 1
The query output is
Material Amount
-
Node 1 140 (7 * 20)
Material 1 40 (4 * 10)
Material 2 30 (3 * 10)
It should be
Material Amount
-
Node 1 70
Material 1 40
Material 2 30
Please suggest how can this be achieved.
Regards
SSS