9 Replies Latest reply: Aug 9, 2011 10:12 AM by mrkachhia RSS

    Expression Wants Between Dimensions

      I have table containing below columns.. (FYI... Orders recevied from our customers sent for execution to our supplier, we are working as an intermediate)

       

      Customer Name

      Customer ID

      Customer Order Number

      Customer Part Number

      Order Quantity

      Order Price

      Supplier ID

      Supplier Part Number

      Supplier Price

       

       

      I want final table with Customer Order Total (=Order Quantity * Order Price) after Order Price column and Supplier Order Total (=Order Quantity * Supplier Price) as a last column.

       

      Please help....!!!