Yes, you can do something similar using just the Pivot table and filters, but you can’t include other useful columns in the report. See next topic for a longer explanation.
Your Rank code might look something like this:
rank(sum(if("Deals"."Stage" LIKE 'Closed Won',"Deals"."Deal Size",0)),'desc')
Though remember, you can choose to rank off any number of variables—it doesn’t have to be exactly what I chose.