7 Replies Latest reply on Oct 17, 2016 6:46 AM by Shinichiro Murakami

    Search For records in table that are within N% of selection in other table.

    L L

      I have two tables on a dashboard and what I would like to do is be able to select a record in one table and on selection find and sort records that are within N% on the bottom table of the selected record in the top table. So you will be able to select which measure value to search on and what percent to be within. I have no idea how to do this, that is why I come to you guys. I have enclosed a sample workbook.