Forum Discussion

Niels_NL's avatar
Niels_NL
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Calculating order total

Hey guys,   situation is the following:   I have a sales-table containing the following columns Ordernumber Product Price Quantity Linetotal   The linetotal represents 'Price * Quant...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi Niels_NL,

     

    if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.

    And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)

     

     

     

     

     

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

Hi Niels_NL,

 

if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.

And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)