6 Replies Latest reply on Aug 24, 2018 5:52 AM by Elizabeth Perry

    Select a top 10 by one field but then sort those 10 by another field

    Elizabeth Perry

      Hi, I have created a top 10 list by '2018 Net', fine that works great - I've sorted my data by which I want to find the top 10, created a field called Index with the calculation Index() added that to filters and edited to show 'at most 10'. But now I want to order / sort that top 10 list by another field within the table view, I clicked on the dimension in the rows area and sorted it with the different field name - completely different top 10 list appears. I'm sure it worked initially but now seems to have stopped. Is there any way to anchor the Index() filter top 10 to a particular field / measure? TIA