Category Summary Report by Price Tier

Does anyone know of a way to get Categories Summary sales by Price Tiers.  I need to know how much was sold as Wholesale, Retail, etc. in each of our categories. Currently, for each price tier, I export an Items Summary Report then sort by category and add up all sales in each category.