Hi, I have the below worksheet.
Doing a quick table calc of % of Total works great until I filter on a particular Brand. The goal is if I was only filtered on 'Blue' Brand how do I get the result to be 'Blue' % of TOTAL Brand?
I need the % of total to work with the filters. If I'm filtered on Petsmart, Dog Dry, and Blue. Then I need the result to be Blue as a percentage of TOTAL Petsmart, Dog Dry. Hopefully that makes sense. I need to consider the total of 'BRAND' always taking the filter of Category and Market and Brand into account. I imagine a LOD calculation but it's not working.