Calculate market share

[Anonymous]

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.

[vvira1316]

Sum(Sales)/Sum({<Region>} TOTAL <Product> Sales)

[zebhashmi]

Sum(Sales)/Sum(TOTAL <Product> Sales)

or

=Sales/Sum(total<Region>Sales)