3 Replies Latest reply on Nov 23, 2011 6:23 PM by johnnychung

    Creating calculated measure on specific members of a dimension

      Hi all,

       

      i am fairly new to Tableau, and got stucked on this issue.

       

      Assume I have the following table

       

      Date  Account  Amount

      1/2/11 Sales    $1000

      1/3/11 Expense    $200

      1/2/11 Sales    $1000

      1/2/11 Expense    $500

      1/3/11 Sales    $400

      1/3/11 Expense    $50

       

      Once i have loaded the data in Tableau,

      I will have “Account” as a dimension with “sales” and “expense” as members .

      And in measures I have amount.

       

      But I need to calculate the profit margin

      Which is sales amount – expense amount.

       

      and show the results in

      profit margin vs Date

       

      How can i achieve this ?