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



      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.