8 Replies Latest reply on Aug 23, 2016 6:54 AM by chris.moore.11

    Calculate market share over time using LOD and quick filter

    Meyser Abduljabbar

      Hi,

       

      This is my first post in the forum. I'm struggling to calculate market share over time using LOD.

       

      This table provides example data.

       

      Market 1

      ProductJan 2015Feb 2015Mar 2015Apr 2015May 2015Jun 2015Jul 2015Aug 2015
      A22212111
      B11111232
      C22123111
      D31131232
      E22212421
      Total10878910107

       

       

      What I want is to calculate the market share for e.g. Product A for every month using LOD and being able to apply quick filter without recalculations.

       

      So for Product A in Jan 2015 that would be: 2/10 = 20% share of market regardless of what products are visualized,

                                    Feb 2015 that would be: 2/8 = 25% share of market regardless of what products are visualized.

       

      If I would filter out e.g. Product C, I would still want the calculations to calculate based on 10 for Jan 2015 and based on 8 for Feb 2015.

       

       

      I hope this makes sense and that someone can guide me through this.

       

      Thanks!

       

      Meyser