1 Reply Latest reply on Apr 12, 2018 11:59 AM by Amber Loranger

    Picking the most appropriate one

    Arshan Manjah

      Hello everyone,

       

      I have a dataset looking like this (this isn't actual data but illustrates the problem):

       

      s1.PNG

       

      What I want to achieve is something looking like this:

       

      s2.PNG

       

      Each bulding should get the latest (by the number of Proposal field) offer. If there's no 3rd Proposal it should be 2nd, if not second, then 1st etc. I don't know how to achieve this in Tableau. If anyone could help me out with this problem I would be realy great for me.

       

      Thanks in advance.