4 Replies Latest reply on Nov 20, 2017 10:49 AM by Deepak Rai

    Comparing a Dimension between two measures

    Manohar Reddy

      Hello All,

       

      The Setup: I have a dimension with product names and its sales for two Sundays as two different measures.

       

      The Requirement: I need to compare the product names by the difference between the measures and generate a result.

       

      I am attaching an example workbook, so I need to compare the sales for Current Sunday vs the Previous Sunday for all the products.

      • If value of Current Sunday > value of Previous Sunday then I would like to display "Good" across that particular product name
      • If value of Current Sunday < value of Previous Sunday then I would like to display "Update Sale" across that particular product name

       

      or (if this is possible to do it will help me a lot)

      • If value of Current Sunday < value of Previous Sunday and the difference is more than 10% then I would like to display "Update Sale" across that particular product name

       

      I am very new to Tableau, please excuse me if this is an already answered question.

       

      Regards,

      Manohar