I have a dataset looking like this (this isn't actual data but illustrates the problem):
What I want to achieve is something looking like this:
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.
Hi Arshan, I don't have a full solution in mind but it seems something using MAX(Proposal) might work?