indexing to 100

[blasooo]

Hi there,

I have a query, hope someone can assist:

I am trying to work out how to index the following as I am trying understand contribution to market:

Market 1: Product A: Sub Product X:
Total = 20000 2500 1000
group 1 = 3000 700 200
group 2 = 4000 700 500
group 3 = 10000 800 200
group 4 = 3000 300 100

I hope the above makes some sense, and I know that I could divide group 1 value by relevant total, but that's apparently not entirely correct due to sample size of population...

 

[blasooo]

I have figured it out. No worries.

 

[S.H.A.D.O.]

I am glad you worked it out.
Perhaps you could post your solution so others searching for indexing criteria or reading this in the future may benefit.
Thanks in advance.