2 Replies Latest reply on Jan 14, 2016 2:14 PM by Mark Groombridge

    Calculation between value of measure related to 2 values in another column

    Mark Groombridge

      Evening - sorry if this is a dumb question or I don't make it clear, I'm new to Tableau and to the forum so please be kind!

       

      I'm trying to create a line graph of our sales figures by date - the SQL data shows all order values as positive in one column (Order Header Total Net), and identifies them as sales or credits by a value in another column (Order Type ID where 1 is a sales order, 4 is a credit etc).

       

      To show the actual sales figure I need to subtract values related to credits from those related to orders before displaying. I've looked into calculated fields a bit but everything I've seen is between fields, whereas this is within a field.

       

      Any suggestions on this would be appreciated please!