Sorry, it seems to be working for me now. I think I had too many workbooks open. The only thing I did notice is that when Brand or Gender is not selected that information doesn't carry over to the breakdown. I would still like Brand and Gender to carry over to the breakdown and be grouped and summed together. When Site is selected you see all Brands, Styles, and Genders get grouped that fall under that site and summed on quantity, sales, and COGS. When Site and Brand is selected you see all Styles and Genders get grouped that fall under that site and brand summed on quantity, sales, and COGS. The same goes for Site, Brand, Gender and Site Gender. Does this make sense? Each filter is meant to provide another layer of detail. The way it does the breakdown when you have site, brand, and gender selected is how I would like it to function the whole way through.