I included a small sample of the data but have a much large data set with 4 categories. I also want to trim the mean because there are outliers. So if you were to choose Warehouse A, and the channel as Big Box the toys R Us average of 225 is really going to throw the number off. Any suggestions on how to do it when I make choices on the categories.