Ranked Calculated Table

Hi    I have a sales transaction table and a customer dimension table.  I would like to create one calculated table that indicates the rank of the total sales per customer ID, but also include all...