2 Replies Latest reply: May 16, 2018 12:09 PM by Jahanzeb Hashmi RSS

    Calculate market share

    Yogendra Wasaikar

      Can some please help  me on how to calculate market share for sales of different products for different region. Below is the example table. In the attached table i want to calculate market share for product A for X region, Y region, etc. Similarly for B product, C product.

      Product, Region, Sales

      A, X, 50

      A, Y, 520

      B, X, 500

      B, Y, 10

      C, X, 800

      C, Y, 400

      C, Z, 200

      Thanks in advance.