1 2 Previous Next 16 Replies Latest reply on Feb 7, 2019 1:10 AM by Shyam Sundar Ranganathan

    Fixed Column Referencing

    Shyam Sundar Ranganathan

      Hello Team,

       

      I have test sales information across location for a supermarket. The idea is that I should have the top 3 products (In terms of Total sales) for a chosen location and I want to compare the measures (Quantity,Average Price) for those products with other locations

       

      Lets say I chose the location to be New York and the location I would like to compare with is California, so the result should have the  top 3 products of New York and the information for those products in California against it. Incase if California do not sell a product that's listed for New York then the value for those measures should be empty

      .
      I have attached a sample tableau workbook. Kindly have a look, looking forward to your solutions.

       

      Thanks,

      Shyam

        1 2 Previous Next