To find the top 10% of the 200 merchants, first sort the merchants in the desired order. Then, create a calculated field similar to the following:
if index()<=(total(countd([Customer])*.1) then attr([Customer]) else ' ' end
To get the third column, simply place the Customer field on the view.
Hope this helps!
I didn't know this function Total. it's super helpful.
That's really great! Thank you!