Hi Randolph, would you help explain the reason behind wanting to repeat Total Sales at a grand total per category even if that category had no sales? I'm thinking this might be a hard view to interpret correctly by your colleagues and there may be a more appropriate layout. If you could help me understand the reasoning behind it, it may help me oor others create a solution.
I'm assuming you want the 12,010 to repeat for ALL sub categories even if that record has a 0. This sheet should help others see what you are attempting to do in case someone else responds first.
I hope this helps.