I want to rank a long list of records that contains groups and sub-groupings. The ranking would be based on each sub-group (e.g. 'Top 3 Products Purchased per Customer'). I think this should be fairly straight-forward but can't figure out how to do it. The data has three variables: Customer ID, Product Name, Number of Products Purchased. So for each unique customer id I need to sort and rank their top 3 products based on number of purchases.
Either of the methods described will be affected by the sort order of the data going into the process. A sort tool prior to the RunningTotal or MultiRow-Formula will change the results that you get. A filter afterward will let you choose the records that you want to keep.