7 Replies Latest reply on Jun 23, 2012 9:15 AM by Joe Mako

    How do I get total sales for distinct orders?

    dalia cohen

      I work in a company that prints books, cards, and calendars, and I am trying to get sales by day by product. I have two tables I'm joining:

       

      1. orders - lists the orders placed and includes information on when the order was placed, who placed it, their credit card information, etc

      2. order items - lists the items purchased in each order (there may be multiple items in the same order).

       

      Tableau is treating each order item as its own order, though, so that when I try to see total sales, a lot of the orders are being double counted. How do I make it get sales for distinct orders? Can I write a calculated field where I group by order ID?