Hi,
I hope you'll anderstand my problem.
I craeted a fact table that observe Status of orders. mean that each order contain a 4 status (Draft, Approval , Action, Final) ===> 4 rows in fact table for each order.
also I need to show orderPrice and customerName.
my problem is how can I calculate price that multiplied in each Order rows?
same in customers?
Thanks.
I hope you'll anderstand my problem.
I craeted a fact table that observe Status of orders. mean that each order contain a 4 status (Draft, Approval , Action, Final) ===> 4 rows in fact table for each order.
also I need to show orderPrice and customerName.
my problem is how can I calculate price that multiplied in each Order rows?
same in customers?
Thanks.