Fair enough. It can be done but I don't know why you would want to do it this way as it is needlessly complicated.
As a Table Box can only return data as it is presented in a table, you are going to need to figure out what are the top 3 customer in the script. As I'm not sure how the data is loaded, I'm going to assume that it is loaded as presented above (i.e. with totals already known in the script).
The first thing you're going to need to do is work out the rank using ORDER BY and the RowNo() function in the script. After loading your data, I loaded it again as follows:
Table:
LOAD RowNo() AS Rank,
Customers,
China,
USA,
Germany,
Singarpore,
Totals
Resident
Table_tmp
WHERE RowNo() ❤️
Order By Totals Desc;
DROP Table Table_tmp;
This will only load the top three values into the QVW and that is how you can display it in a Table Box. If you don't know the Totals, then you are going to need to work that out in the script too, which adds another layer of complication. In summary your app will be needlessly clunky.
You can see my attached example. It contains the Chart Table and Table Box approach.
