3 Replies Latest reply on May 18, 2016 9:17 PM by Rohan Malusare

    Creating a Calculated Field to Compare Revenue Between 2 Weeks

    Kevin Henely

      Hello,

       

      I have revenue data for different products spanning two weeks.

       

      My columns are: Product Name, Week and Revenue.

       

      What I'm trying to do is create a calculated field that would give me a 1 if week 1's revenue is greater than week 2's for a given product, and a 2 if the reverse is true.

       

      However, everything I try doesn't work, I thought using a parameter as a variable would work, but I get errors there as well.


      Any tips you could provide would be greatly appreciated as I am just learning Tableau now.