This is not currently possible exactly as desired. However, by messing with some of shading of the sheet and the levels of column banding, it's possible to get "rid" of some of the lower headers. I've attached a very rough example. Hope this helps!
Thank you for your reply. How about changing the Total to apply to Total Store Sales and not broken by the lower level hierarchy? Is there a way to adjust the function to give the total when added to the sheet? When I add the Total Store Sale to the sheet it breaks it automatically by sub hierarchy even though the data is not broken at that level. If you look at the image I attached, I only want the far end total appear and not the broken subhierarcy for the Total Store Sales.