Project two columns into a new table sorted differently

[lordbah]

The end result I want is two pieces:

1. Data entry area, columns are Name, Points, Week 1…N. Points is a sum of Week 1…N. Sorted alpha on Name. Easy enough.
2. A second view on the same data, read-only, columns are Name and Points, sorted descending on Points. Automatically updates when new data is entered in the data entry area.

2 is the part I can’t figure out. Is there a link somewhere which walks through this scenario? I would expect it to be common for people tracking competitions. Various things I’ve read always have problems, like copying 0 for the Points column instead of the computed total, or circular reference errors. I tried a pivot table but when I told it to sort the Points column it would do only that, without rearranging the associated columns for each row.

I have version 7.3.7.2 on PopOS.

[Villeroy]

Data>Sort…
Option “Copy sort results to …”

[lordbah]

That’s the one which copies zeroes instead of the total Points.