Hello all,

I am working on presenting a pile of data, I can group this data into Product ID and subsequent grouping of multiple Batch IDs for each product.

For example Product #001 has 1000KG in stock,

of that 1000KG, there are 5 batches, Batch A has 700KG, Batch B has 100KG, Batch C has 50KG and so on...

Product #002 also has 1000KG in Stock,

of that 1000KG, there are 5 batches each of 200KG.

I was hoping to be able to have a single value to represent this spread (such as the standard deviation but more simpler to identify straight away)

For example since Batch B has all the same batch size I could represent this by a 0, and Batch A could be represent by 0.7 because 1 batch accounts for 70% of the product.

From looking at my powerpivot I am finding it tricky to do these calculations.

Any one any ideas on how to work this?