5 Replies Latest reply on May 4, 2019 5:11 AM by Jim Dehner

    Market share % calculation, filter is not working for other sheets

    sunil joshi

      Hi All,

      I have used a table calculation to compute the market share %. 

      SUM([Value]) / TOTAL(SUM([Value (]))

       

      When I am using the Brand filter it showing 100% for each Brand,

      then I have also created a Brand filter below which is working fine but this filter is not applying to other sheets.

      Please suggest how to do that.

      I can't upload workbook because it is too heavy.

       

      Regards

      Sunil