Using the Rank Formula to Sort Accounts

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.

Back to Lesson