5 Replies Latest reply on Dec 15, 2016 9:46 AM by mozammel chowdhury

    Based on Highest Amount Choose that identical Row

    mozammel chowdhury

      Hello I have a situation where I am needing to only retain the column that has the highest value. I am attaching an example file for better understanding. So in the file A,B,F and G has multiple category and multiple amounts. The rest has only one. The tableau function should lookup the amount and see which one is the highest for that desc and retain only those rows. The spreadsheet shows and Initial view and a Final view as to what I am referring to. Any help will be appreciated