1 Reply Latest reply on Nov 22, 2013 12:52 PM by Mark Smith

    Creating Retailer Tier based on Purchase Volume

    Spenser Tangman

      I need to make merchant tiers in order to compare the ratio of bikes to accessories available based on the number of sales per retail location.  ALL DATA IS FICTIONAL.  The issue that I'm having is that the retailers may sell both bicycles and acccessories (other) but I want to create tiers for the merchants based on total purchases (bikes+accessories) regardless of their Merchant Condition Code (MCC).

       

      I have attached an example workbook where you can see that the calculated field for Market tiers creates a tier for bike sales and another tier for accessory sales, but does not recognize the sum of the two for the calculation.  Can anyone give me a few tips? I know

       

      Thanks for your help!