1 Reply Latest reply on Dec 21, 2016 2:48 PM by Shinichiro Murakami

    % of Total - Maintain total of dimension


      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.