5 Replies Latest reply: Dec 27, 2016 11:50 AM by Javier Vicente RSS

    How to use a flag to seperate online sales from direct sales?

       

      I have a Sales_Header table with a field called WebsiteOrderFlag. -1 identifies sales through website and 0 identifies sales through a salesperson. I would like to separate online sales using a flag and then add OnlineSales as one of the Sales Representative in the SalesPerson table to show total sales by each salesperson and total sales through the website. Could anyone please help? Thanks